Skip to Content

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.

achi1.PNG

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.

 

 

/wp-content/uploads/2013/10/ach3_294991.png

 

Hope this is helful to make interactive dashboards.

 

 

 

Regards

Shabnam

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply