Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a requirement where a user can select the measure i.e show by Percentage or by Number .
How can I implement this :- How to show a user a chart depending on what he choose -
I am using variable like below :
set vDisplayedByShow='Number,Percentage';
set vDisplayedByShow='Percentage';
Other option is create a inline table:
ShowAs:
LOAD * INLINE [
ShowAs
#
%
];
and then use it inside the expression to change the formula :
if( ShowAs = '#', num(Sum (Quantity), '#,00'), num(Sum (Quantity) / Sum (total Quantity), '#,00%'))
Hi @ashmitp869 , one option is having more than one expression, and then group them :
First, create the desired expressions, in this case, 3
Then, group them :
and again, group the third expression :
So, now you have 3 expressions grouped :
And you can change the expression using the button :
Other option is create a inline table:
ShowAs:
LOAD * INLINE [
ShowAs
#
%
];
and then use it inside the expression to change the formula :
if( ShowAs = '#', num(Sum (Quantity), '#,00'), num(Sum (Quantity) / Sum (total Quantity), '#,00%'))