Chart Axis Range Maximum

[Philbo]

Hi All,

I have a line chart plotting values (y) by date (x). a couple of the data points are much higher than the majority, and ideally I'd like to cap my Y axis at a low value (e.g. 10) so the detail of the lower values can be seen, and the higher values (e.g. 1,000) disappear out of the top of the graph. I don't really like logarithmic scales as I think they can be easily misinterpreted.

I assumed the Manual Maximum option in the Axis Range properties of the Y axis would allow this, but setting this does not seem to work. Either the functionality simply doesn't work, or Cognos will not allow a maximum that is lower than your highest data point. I suspect it's the latter.

Does anyone have any feedback on this? either if I'm missing something, or there's another way of achieving this, or anyone that's encountered similar isssues?

Thanks in advance.

[MFGF]

Hi All,

I have a line chart plotting values (y) by date (x). a couple of the data points are much higher than the majority, and ideally I'd like to cap my Y axis at a low value (e.g. 10) so the detail of the lower values can be seen, and the higher values (e.g. 1,000) disappear out of the top of the graph. I don't really like logarithmic scales as I think they can be easily misinterpreted.

I assumed the Manual Maximum option in the Axis Range properties of the Y axis would allow this, but setting this does not seem to work. Either the functionality simply doesn't work, or Cognos will not allow a maximum that is lower than your highest data point. I suspect it's the latter.

Does anyone have any feedback on this? either if I'm missing something, or there's another way of achieving this, or anyone that's encountered similar isssues?

Thanks in advance.

Hi,

In this situation you wouldn't see the higher values rendered in your requirement, so it's probably easiest to just filter them out or conditionally change them to a null?

Cheers!

MF.

[Philbo]

Thanks very much for the reply.

So even if it did work, I wouldn't see the data point at all? That's not what I want either. I could adapt the code to set a maximum in the value derivation logic, but then the actual value isn't displayed. Ideally I'd break the axis to show upper range of values.

I'm playing around with having a Logarithmic axis, which does help to show the lower values in more detail, so I guess i'll go with that.

[dougp]

(My answer is not strictly limited to Cognos 10, but the good subject line makes this a likely place to land on a search.)

Charts in Cognos 10 refuse to honor the user-set maximum value for the y-axis of a chart.  But they will honor the minimum value.  Apparently, large values are too important to hide, but it's OK to hide the small (or negative) ones.

I am attaching a screen capture that shows an example from Cognos 11.0.13 that compares line charts from new visualizations, legacy visualizations, and charts.  I have set the minimum and maximum y-axis value for each chart.  Some observations:

• The maximum value is ignored in [Cognos 10] charts if the maximum value of the data exceeds the user-set limit.
• In new visualizations, the chart is not limited to the user-set values.  There is a little bit of a buffer around it.
• [Cognos 10] charts allow the user to select "Automatic" for either end of the range.  Both the new visualizations and legacy visualizations require both upper and lower ends of the range to be manually set if the range is user-specified.
• There appears to be no way to dynamically choose axis ranges for any of these options.

The legacy visualizations I see in Cognos 11.0.13 may be the ones available for Cognos 10.