Specifying a default value for missing data

[#1]

I have a report for which I generate a 'Master Calendar'. For dates in the future for which I have no data yet for a particular field expression I want to populate a default value. On a chart how can I specify a default value to use when no value is present in my source database? What I really want to do is pull a default value from my database and use this in places where there isn't specific data available for a particular date.

[#2 · Accepted solution]

I dont know what you want.....

but you can do this in script .....for example.....IF(ISNULL(your field), 'put a default value' , your field)

or on the chart

you can enable a POPULATE MISSING CELLS

and put you default value in a fields Null Symbol or/and Missing Symbol...

did you tray that??

[#3]

Using the conditional in the expression worked. Earlier I had tried this but had a logical error that was causing things not to display as I wanted.

[#4]

Great.. I used it as an calculated dimension. In a case where you had male, female, -. Where the '-' needed to be replaced by 'Unknown'.