asked 3 days ago
Hello again dear Flexmonster Team!
We created a pivot displaying months in the rows and the distinctcount of a value as measure. Now we would like to see the changes of this aggregate over the months. So we'd like to do something like this: differenceofrows(distinctcount("value")) but this only results in empty cells.
Is there a way to achieve this somehow?
Again I've attached a simple mockup to illustrate our idea.
Kind regards,
Florian
⋅ 1 day ago
Hello, Florian!
Thank you for reaching out to us.
Kindly note that in Flexmonster the aggregations like differenceofrow, percentofrow, runningtotalsofrow are calculated based on one default aggregation - sum for number and time fields, and count for other field types.
You can read more about Flexmonster aggregations by the link: https://www.flexmonster.com/doc/aggregation-functions/#available-aggregations.
Hope it helps.
Kind regards,
Solomiia
