Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a dimension and I want to calculate the maxium value from my data. In the example I saw it says it should be calculated by the following expression:
$(=max(aggr(sum(sales), OrderDate)))
I already tried but I didnt get any successful result. Can someone help me out?
How can I calculate the maximum in the expression where the data has different dimension but I want to calculate the maximum value from all my data. I read it can be calculated using the expression $(=)
Any thoughts?
BTW, if you have multiple months, each month will have its own row, and you need max value per row, not global - remove month from the aggr. It will be:
if(secondarydimensionality()=1, sum(Numbers), max(aggr(sum(Numbers), Weekday)))