Chart Missing Observations

I'm having trouble with a combination chart. I'm using the old-school chart because same vis in the Legacy Visualizations and New Visualizations forces a second values axis with a different scale on the right. I don't want that.

The trouble I'm having is that not all of the observations are showing up. I have a page with a chart and a list. Both use the same query, but some observations are missing from the chart.

Chart Missing Observations

[MATSLabNumberNumeric] = cast ( substring ( [MATS Lab Number], 6 ), int ) where MATS Lab Number is like FA0200088 (for the first observation in the list). All observations are displayed if the MATS Lab Number is used, but not if MATSLabNumberNumeric is used.

I have had the same results in all combinations of these:
Cognos Analytics 11.0.13
Cognos Analytics 11.1.7
Interactive Viewer
Compatible Viewer
11.4 styles
10.x styles
combination chart
bar chart
column chart
area chart
line chart

Any idea what could be causing this? Is there a property I inadvertently flipped?



Read more here: https://stackoverflow.com/questions/66323629/chart-missing-observations

Content Attribution

This content was originally published by dougp at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: