Use of labels for interactive charts in Dashboard

[Former Member]

Just a small demonstration of using Label for interactive charts.

 

We can give user option to show only one measure out of(actual,standard and krate) at one time in chart and show % growth  %achi based on selected measure.

 

A= actual

S=standard

K=krate

LY = Last Year Sales

 

achie% = (budget - A/S/K)/budget *100

growth% = ( LY - A/S/K)/LY * 100

 

Desired output will be as below.



We can achieve this by using simple label component.

 

In behaviour tab of label we will use below settings. Labels we will map with Actual, Standard and Krate as Required.

 

Insertion type should be Column and in source we will map all three measures coming from Bex query or unv and destination can we a blank column which  can be used to keep value of any one selected measure(Actual/Standard/Krate).

 

If user selects actual label, actual value will be stored in destination and we can write a formula for dynamic calculation of %achievement and % Growth.

 

 



 

Hope this is helful to make interactive dashboards.

 

 

 

Regards

Shabnam