Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In the Dashboard I have a multi box which has following values
A
B
C
D
E
now based on the selection I need to pass value to set analysis expression
Lets Say if I select A and B then the expression should be
=Sum({<ColumnValue={'A','B'}>} Amount)
if I select A ,B and C then the expression should be
=Sum({<ColumnValue={'A','B','C'}>} Amount)
If the field in the multibox is ColumnValue then you don't need any set modifier. sum(Amount) will do what you want. If it's a different field then use =Sum({<ColumnValue=P(MultiBoxFieldHere)>} Amount) and replace MultiBoxFieldHere with the name of the field in the multibox. And it has to be a field, expression do not work.
That is same as simple = Sum(Amount) // only the selected values would be considered, isn't it?
Hi Manoj,
Create 1 variable eg
v_var = getfieldselections(ColumnName,',')
and use this expression in chart
sum({$<ColumnName={$(v_var)}>}Amount)