Graph scale with y-axis values < 5

building reports webintelligence
1

Quick question. I’ve searched and searched for this but didn’t find any threads where there was an actual resolution.

I’m using a bar graph to display number of calls received over x time frame, this works fine as long as the total calls are over 5 for any given time frame. Once the calls drop below 5 for all the time frames displayed the y-axis scale adds in 2 decimal places. So instead of 1,2,3,4,5 I have 0.00,0.40,0.80,1.20 etc. I’ve tried setting the minimum scale to 1 but this doesn’t work. It fixes the issue if I set the maximum scale but the problem here is that I’m trying to use it with a drill for multiple queues whose maximum call volumes vary wildly (one may only get a max of 3 calls any given time frame while the other might get 500).

Is there any way around this or is it just a shortcoming of Webi?

Thanks,
Steve

logos (BOB member since 2011-03-14)

2

A bit of a bump here…

I’d also like to know if there is anything that can be done about the above.

:slight_smile:

Evied (BOB member since 2010-05-17)

3

Have you tried checking the Logarithmic scale option? This problem may not occur there.

SAP_BO_Addict :canada: (BOB member since 2003-09-18)

4

Try changing the format to “##”…

sati_sunil (BOB member since 2010-09-16)

5

Steve,

Create two graphs, one with each scale and hide the appropriate one based on the call count.

6

Mark, That’s a really good idea! Hadn’t thought about that, I’ll give it a go.

Thanks,
Steve

logos (BOB member since 2011-03-14)

7

Hi Logos,

Have u tried with 2 graphs. Did it worked??

vicky111 (BOB member since 2008-07-08)

8

No, I haven’t. Though the solution should work without issue.

logos (BOB member since 2011-03-14)

9

Hellow Everyone,

Even im trying to get y-axis valuse 1-500 bus it starts multiplying as the max value increases 12.

Any solution so far ??? :?

lucy.online :us: (BOB member since 2012-04-03)

10

Custom format your Y axis to “00”

mikca :australia: (BOB member since 2005-12-16)

11

But when i set max value more then 12 the values starts * 2 if the value is odd then +2
??? And my requirement is i wont to display all no from 1 to 500…

Thanks for replying. :mrgreen: :+1:

lucy.online :us: (BOB member since 2012-04-03)

12

You could export to excel and then set y axis preferences there however if you have every number from 1-500 on the axis your information will be lost in the noise.

Mick

mikca :australia: (BOB member since 2005-12-16)

13

Thanks mick for replying…
I will try that…
:+1:

one more thing just for my knowledge when we select a chart is there any parameters were we can set the y-axis values default valuation…
eg:when i select max value 20 it *2 can we edit that valuation?

Thanks :mrgreen: :+1:

lucy.online :us: (BOB member since 2012-04-03)

14

There are properties for BO charts. They are somewhat limited and counter intuitive but values come from your source data. To set properties open the properties editor expand it to show all properties (quite a few) and have a play to see what you can do.

Mick

mikca :australia: (BOB member since 2005-12-16)

15

ok thanks Mick for your help. :+1: keep it up… :mrgreen:

lucy.online :us: (BOB member since 2012-04-03)