COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: JakeTheSnakeRoberts on 25 Aug 2014 08:24:10 PM

Title: stacked chart axis minimum value
Post by: JakeTheSnakeRoberts on 25 Aug 2014 08:24:10 PM
Hi all,

I am having an issue with rendering the primary y axis in a stacked chart. I wasn't my minimum value to be 600000 and max 650000. I set this up in the properties but it renders the bar below the minimum baseline.

Any ideas hugely welcome!
Title: Re: stacked chart axis minimum value
Post by: ToriBurns on 25 Aug 2014 09:39:13 PM
I wonder if adding a filter would help. Add a filter with an expression that limits the measure to a minimum value of 600000 and maximum value of 650000.

Like:

[Measure] > 600000
[Measure] < 650000

I hope you'd get the point. Hope it helps. :)

Cheers,
Tori
Title: Re: stacked chart axis minimum value
Post by: JakeTheSnakeRoberts on 25 Aug 2014 11:44:13 PM
Thanks for your reply,

Unfortunately it wont work when doing a stacked bar and the other items are for example 5k or 10k.

Interestingly the problem does not exist when I use the legacy chart.

Thanks again