Value Aggregation
Last updated
Last updated
Once we apply to the group, we can apply value aggregations to the group headers. Click the hamburger button of the respective column on which you want to apply value aggregations. Expand the ‘Value Aggregations’ tab and select the aggregation function. Below is a screenshot of the ‘Value Aggregation’ tab.
Vitara grid chart allows applying only the aggregation functions which are listed in the ‘Value Aggregation’ tab. The default aggregation function is ‘Sum’.
In the ‘Value Aggregation’ tab of the grid chart, there are some basic functions that can be used to apply aggregations. If we want a function other than these functions, by using the ‘Choose Column’ option in the ‘Value Aggregation’ tab we can implement it.
It is possible to use aggregation from a different metric (say metric B) as the aggregation for metric A. The way to set it up is to use both metric A and metric B on the grid. Now metric B is something you would define having the right type of aggregation at the desired dimensionality. On the Vitara Grid column for metric B, you would just choose a trivial aggregation (like first or last).
In the column for metric A, choose aggregation and choose a column to select metric B. Now you can just hide column for metric B if you don’t want it displayed.
For example, in the below screenshot group by is applied at the ‘ Category’ level. I want to show ‘value aggregation’ for profit metric as (Profit - Shipping Cost).
But using the Vitara grid chart ‘Value Aggregation’ formulas I can’t define this aggregation. The following is the procedure for defining this aggregation.
Define a derived metric using the formula we want in aggregation. Let us assume the derived metric name is ‘Actual Profit.’
" Actual Profit = sum (Profit - (Shipping Cost ) ) "
Add this metric to the grid chart.
We can verify in the screenshot, the value of ‘Actual Profit’ metric, is it showing exactly (Profit - Shipping Cost). The aggregation functions applied for ‘Profit’ and ‘Shipping Cost’ is Sum.
Apply aggregations like First, Last, Max or Min for ‘Actual Profit’ derived metric.
The derived metric ‘Actual Profit’ currently displays the correct aggregated values that should also appear under the ‘Profit’ metric. To replicate this aggregation in the ‘Profit’ metric, open the ‘Value Aggregation’ settings for ‘Profit’, navigate to ‘Choose Column’, and select the derived metric ‘Actual Profit’.
Step 5:
Now, as we defined the derived metric ‘Actual Profit’ for calculating value aggregation for the ‘Profit’ metric and we don’t need this metric in our grid chart, we can hide this metric. Click on the hamburger button of the ‘Actual Profit’ metric and select ‘Hide Column.’
Screenshot after hiding the ‘Actual Profit’ metric
In Vitara Grid chars we have a new aggregation function called ‘Ratio’. We can implement a ratio of two metrics as aggregation in the chart. The following is the screenshot of the ratio option.
When we select ‘Ratio’ as aggregation function a new ratio editor window will open. Below is the screenshot of the ratio editor window.
Apply all the required fields and click on the ‘Apply’ button.
