Vertical lines in scatter plot to represent various ranges

building reports webintelligence
1

In scatter plot in web intelligence.
Y-axis represents total revenue and x axis represent grading (0-100)
I would like to draw static vertical line at 25, 50 and 75 with different colour, it will divide scatter plot into four regions.

Any idea, how can I draw these lines in webi.
Thanks in advance

GBS74 (BOB member since 2007-01-23)

2

Have you tried creating four variables as measures:
Group 1: =25
Group 2: =50
Group 3: =75
Then assigning this data where it will show in the vertical axis in your chart?

You should be able to right click on the specific lines and use format data series in the chart to assign a custom color that is constant.

tendernips (BOB member since 2017-07-27)

3

thanks , but I am still struggling.

I have two measures: revenue and grading
In Assign data, there are 4 parameters :
Value Axis 1 = Revenue
Value Axis 2 = Grading
Region Colour =
Region Shape =

I have tried to fill Region Color and Region Shape with group variables(you have suggested) but not getting any where. Could you please explain it little more.

Thanks

GBS74 (BOB member since 2007-01-23)

4

Try clicking the little plus next to the value axis 2 Grading data group and select group 1 variable, then do the same for 2 and 3. This should add the constant lines to the chart itself.

Right click on each of the groups’ lines in the chart and click format data series, then click custom radio button. You can change color, opacity, and line style/size, though I don’t know if there’s any way to remove the dots at each interval along the line.

edit: I thought the simple constant variables might give you a way to get a line, but now having looked at the options n a scatterplot it will only give you a dot and I don’t think you can change the actual display for each series.

You might try making an overlay bar chart with variables like =if [Grading] =25 then Max([Revenue]) in report +100 so it dynamically adjusts then make the bars 1-2 px wide in formatting for the 25 50 75 values. You can then make the background transparent and change the colors for each bar.

tendernips (BOB member since 2017-07-27)