Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to make an aggregation inside of an expression of a CALCULATED dimension?
I have a table with a calculated dimension and I need to use an aggregation on that... but I am not sure that is posssible...
Let me know
Thanks in advance
Yes you can. But you will need to use an Aggr function. Example:
=Aggr(distinct Count(OrderID),Product)
will create an array of numbers that represent "On how many orders does the the product X appear?"
Basically, the Aggr function creates an array using the first parameter of the Aggr function (which must be an aggregation) and the second (third, fourth, ...) parameter is equivalent to the GROUP BY in SQL.
/HIC
Henric is right... but, in some cases, the aggregation could be a contradiction with the dimmention.
Please, tell us the Calculated Dimmention you have and the Aggregated expression you need.