Sales Dashboard

List: Orders
Fields: Total

Group by: empty

As you can see the empty field doesn’t exists in the data source. We use it here to calculate aggregate values over all rows in the data set because for each row it equals to “undefined”, thus we get a single group containing all items.

Aggregations:
Total = sum of Total

Type: Linear Gauge
Value: Total

List: Orders
Fields: Total

Group by: empty

As you can see the empty field doesn’t exists in the data source. We use it here to calculate aggregate values over all rows in the data set because for each row it equals to “undefined”, thus we get a single group containing all items.

Aggregations:
AvgTotal = average of Total

Type: Linear Gauge
Value: AvgTotal

List: Orders
Fields: SalesRep, Total

Group by: SalesRep

Aggregations:
Total = sum of Total

Type: Bar
Display each group as a separate series: False
Category: value
Value: Total
Aggregate over category: False

List: Orders
Fields: SalesRep, Total

Group by: SalesRep

Aggregations:
Total = sum of Total

var handlers = {};
handlers.aggregationSuccess = function (data, logger) {
    data.groups.sort(function (a, b) { return a.Total <= b.Total ? 1 : -1 });
 
    var total = 0;
    $.each(data.groups, function () {
        total += this.Total;
    });
 
    $.each(data.groups, function () {
        this.Percantage = this.Total / total * 100;
    });
 
    return true;
}

The code above calculates individual rank of each sales representative in total revenue in percent.

Type: Column
Display each group as a separate series: False
Category: value
Value: Percantage
Aggregate over category: False

Value axis:
Label format: {0}%

var handlers = {};
handlers.preRender = function (config, logger) {
    var data = [];
    $.each(config.series[0].data, function (i) {
        if (data.length == 0) {
            data.push(this.Percantage);
        } else {
            data.push(this.Percantage + data[i - 1]);
        }
    });
 
    config.series.push({
        type: 'line',
        data: data
    });
 
    logger.debug('Configuration: ', config);
    return true;
}

Here we populate a new data series with cumulative values, that increase from one salesperson to the next, representing meaningful change. Next, we build a line chart based on the new data set.

List: OrderItems
Fields: Amount, Product:Category

Group by: Product:Category

Aggregations:
Total = sum of Amount

var handlers = {};
handlers.aggregationSuccess = function (data, logger) {
    data.groups.sort(function (a, b) { return a.Total <= b.Total ? 1 : -1 });
    return true;
}

Sorting groups by total revenue.

Type: Bar
Display each group as a separate series: False
Category: value
Value: Total
Aggregate over category: False

List: Orders
Fields: Customer:Country, Total

Group by: Customer:Country

Aggregations:
Total = sum of Total

var handlers = {};
handlers.aggregationSuccess = function (data, logger) {
    data.groups.sort(function (a, b) { return a.Total <= b.Total ? 1 : -1 });
    return true;
}

Sorting groups by total revenue.

Type: Bar
Display each group as a separate series: False
Category: value
Value: Total
Aggregate over category: False