Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Agregar un boton para ver dos opciones en mi graficos tanto para valor numerico como porcentaje, he creado mis dos variables como formatonumerico y formatoporcentual pero al crear mi boton no se ve reflejado en los graficos al mostrar. Podrian decirme como desarrollarlo
My Spanish is rusty but if I understand you correctly, then you only need one variable for this functionality.
With the button you can toggle the value of the variable between 1 and 0.
In your expression you can then decide with the value of the variable, which format to display.
IF($(vFormatOption) = 1, Sum(Value), Sum(Value) / Sum(Total Value) * 100)
In this example if the variable vFormatOption = 1, then display the normal numeric value. Otherwise (vFormatOption = 0) display the percentage value.
To make the button toggle between 1 and 0 you can use this function:
=if(<your_variable>=1, 0, 1)
Hope this helps.