Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dimension Step and expression - Unique Customer (sum([Customer Count])). i want to create max of Unique Customer but unable to do so with max(sum([Customer Count])). How do i get the results as shown below?
or with suppress null
Max(TOTAL Aggr(Sum({< Step_Nnull ={"*"}>}[Customer Count]), Step_Nnull))
as expression
Hi,
1 exmpl
max(total aggr(Count(Customer),Customer ))
I think it would be like this
Max(TOTAL Aggr(Sum([Customer Count]), Step))
I got the total of all customer count instead of the maximum though..
I will like to get max([Unique Customer]). but QV is throwing error - bad field name(s) for Unique customer as it is a label
Would you be able to post screenshots without label names and extended columns so that I can see what expressions you are using? Also, Step is the only dimension in this chart? or are there more then that?
Hi Sunny,
Sure. Below is the screenshot excluding label. Also, Step is the only dimension in this chart and i did suppress when it is null value. Third column will be Max(TOTAL Aggr(Sum([Customer Count]), Step_Nnull))
Thanks for your help.
Can you add another expression and share a screenshot (Max without total)
Max(Aggr(Sum([Customer Count]), Step_Nnull))
Sure.
This is how it looks like:
Hi
i think it is showing the correct data. is there any null value in step_Nnull field. My guess is you have null and the Sum([Customer Count]) for that is 506,014,721
try to uncheck suppress null from dimension and use these expression. share the screenshot after that. null should not be suppressed.
Sum([Customer Count])
Max(TOTAL Aggr(Sum([Customer Count]), Step))
regards
Pradosh