Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have created dashboard which has multiple charts dependent on formulas. Now suddenly requirements get change.
Now we want button which shows data in Number & % on click.
I have Product dimension & following formula in expression:
Sum({<Handled_By={E1},Task={'T1','T2','T3'}>}Efforts_Hrs)
I want to show this chart in number and % also on click. What formula should I write to convert this in %. I tried "Relative" option but it does not fulfilling my requirements.
do we have any short way to do this changes in whole dashboard? thanks in adv
If I understand your requirement correctly, I would address this by creating a second expression in the chart that shows the results in %, then make both expressions conditional. Then you can create a variable that is toggled by a button and insert that variable into the condition for the expression.
See Attached !