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.
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.