Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Alternate sets G , B defined in a dash board.
One Bar Chart defined with dimensions A -->This is field item and ValueList('G','B') -->This is Calculated dimension where G , B are not field items.
Expression is as follows.
if(ValueList('G','B') = 'G',Avg({G}C),if(ValueList('G','B') = 'B',Avg({B}C))) ---> Here C is field item.
I would like to know what is happening with above expression.
Could anybody help on this?
Thanks.
by using the value list
in one expression
you use to different sets of data
G,B are alternate states which mean are two different set of the data the selection on each set doesn't effect the other
This expression seems to be comparing the Avg(C) based on different selections in two states. Have you tried to build the scenario to see what it is doing? I think the best way to understand what an expression is doing it to make a small application and see what happens when you make selections.
Thank you all