cancel
Showing results for 
Search instead for 
Did you mean: 

How to show two different lines for two KPI's in column chart of Webi report

0 Kudos

Hi Experts,

Please help me on webi column chart to show two different measure lines on top of two KPI Bars.

I have attached an example screenshot for better understanding.

I want to show the lines like highlighted.

Thanks

Guruprasad G

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

have you tried with combined column chart with 2 axis?target line you use in the second axis as two measure objects.

0 Kudos

Thanks for this option Amit,

I have tried this before, but this option also showing the results as two lines up and down for the entire chart.

I need to display the line on each KPI's(ex: On Deskphone one horizontal line and on Jabber one horizontal line.

Let me know if we have any other options to achieve this.

Thanks

Guruprasad G

amitrathi239
Active Contributor
0 Kudos

create multiple variables for each KPI's and add those in the second axis.after that you will get one line for each KPI.

0 Kudos

Hi Amit,

Created two separate variables for Deskphone and Jabber, still i am getting the same result.webi-chart.png

Deskphone=[S_Target >80] Where([A]="Desk Phone")

Jabber=[S_Target >80] Where([A]="Jabber")

In Value Axis 2 i have assigned these 2 variables.

amitrathi239
Active Contributor
0 Kudos

might be it is happening due to the different scaling of both axis..if you know the range of second axis and set the min & ma scaling range instead of auto scaling.

0 Kudos

Hi Amit,

Thanks for your response, have achieved this using combined column line Chart with 2- Y axis.

Thanks

Guruprasad G