Skip to Content
Author's profile photo Former Member

Use of labels for interactive charts in Dashboard

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



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.






Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.