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.
[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
Any idea what could be causing this? Is there a property I inadvertently flipped?