Print Page - Default Values for Visualizations Unless There is A Data Point

Title: Default Values for Visualizations Unless There is A Data Point
Post by: hnnor on 25 Nov 2019 02:39:48 PM

I would like to create a continuous monthly view of some data. Ex: the x-axis will have all the dates in that month.

The data I have will only have a few of those dates in the month.
Ex:
Date,Value
2019-11-05,0.8
2019-11-20,0.9

Is it possible to have cognos default to a value (1) if no data point is present in the given data so it will show a continues line graph of all the dates throughout the month?

Title: Re: Default Values for Visualizations Unless There is A Data Point
Post by: dougp on 25 Nov 2019 06:09:25 PM

You may need to do that in the data. What are you using as a data source? (package, module, data set)

Title: Re: Default Values for Visualizations Unless There is A Data Point
Post by: hnnor on 26 Nov 2019 09:29:13 AM

I'm using a data module that's connected to a postgres database.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Dashboards => Topic started by: hnnor on 25 Nov 2019 02:39:48 PM