Skip to Content
0

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

Feb 09 at 03:09 PM

53

avatar image
Former Member

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

new-function.png (26.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Feb 09 at 03:28 PM
0

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

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0

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
Former Member

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.

webi-chart.png (29.5 kB)
0

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
Former Member

Hi Amit,

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

Thanks

Guruprasad G

0