If you are unable to create a new account, please email support@bspsoftware.com

 

Default Values for Visualizations Unless There is A Data Point

Started by hnnor, 25 Nov 2019 02:39:48 PM

Previous topic - Next topic

hnnor

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?

dougp

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

hnnor

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