How about some examples of all aggregation functions?

Answered

I am particularly interested in %difference, and the docs just says “Calculates the difference between two values in the row/column expressed in percentages”, but it’s not clear to me how I should specify the values that should be used. The same goes for some other aggregation functions as well.

1 answer

WebDataRocks Team WebDataRocks February 25, 2020

Hello, Alex,
 
Thank you for contacting us.
 
We would like to kindly provide some explanation about the way the %difference aggregation works:
The result of such aggregation will be a percentage difference between the previous and the current value. E.g., in case your data set contains the “Month” hierarchy with two members: “April”, “February”, and the measure “Income”, the result of %difference aggregation will be a difference between “February” income and “April” income presented as a percent. The value for the first member appearing on the grid will be empty due to the fact that it does not have any members before it.
 
Please check out a CodePen we have prepared for you, demonstrating the described example.
 
We hope it helps.
 
Kind regards,
WebDataRocks Team