Number & %

[#1]

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

[#2]

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 !