COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sergiord2016 on 03 Apr 2017 05:42:38 PM

Title: how to set a concrete value as the "zero" in a graphic axis
Post by: sergiord2016 on 03 Apr 2017 05:42:38 PM
hello ,

i want 100 to be the zero of my Y axis.

(http://i67.tinypic.com/25qxk5y.jpg)

I want this grpahic to have he 100 value instead of the 0 and the id's with less than 100 measure to appear below the X axis.

could you help me please?
Title: Re: how to set a concrete value as the "zero" in a graphic axis
Post by: hespora on 04 Apr 2017 03:29:42 AM
The most simple solution I can think of: Replace [cumpl] with [cumpl - 100]. Serves exactly that purpose.
/Edit: You could of course also just add a numeric baseline at 100.

Other than that, I'm looking through the properties of a Bubble Chart right now, and I do not see an option to move the axis intersection.
Title: Re: how to set a concrete value as the "zero" in a graphic axis
Post by: sergiord2016 on 04 Apr 2017 03:40:36 AM
Hi Hespora , thank you for the reply , but i am in the same case.

I did what you say and look:

(http://i65.tinypic.com/iygbac.jpg)

I want -20 values ,-40 ,  -60 below the X Axis , becasue i want the 0 where -60 is now.

How can i put the zero where de .60 is? and make the negative values blow de X axis?
Title: Re: how to set a concrete value as the "zero" in a graphic axis
Post by: hespora on 04 Apr 2017 04:39:22 AM
Hum... you're right. I'm not finding any option to move the x axis or to set the intersection at a specific value (i kinda assumed that it would default to zero, not to the minimum value, which is why i suggested the measure minus 100).

I guess you can always insert a baseline at your 100 value, and remove the x axis line. However, then you'll either omit the x axis major intervals, or have to also manually place those.
Title: Re: how to set a concrete value as the "zero" in a graphic axis
Post by: sergiord2016 on 04 Apr 2017 08:22:32 AM
Yes , numeric baseline would be the best option.

Thank you very much.