Fill up missing date values

[malmsteen1977]

Hi all,

i have a very simple report, screenshot is attached

Dimension is Date

Expression is in the screenshot also

My challenge is that I want to fill up all the dates that are missing in the chart with the value 0

For example I want to have the dates between the 04.01.2017 and the 12.01.2017 filled up with the missing dates (05.01-11.01) and the value 0, something like this:

Date	Value
05.01.2017	0
06.01.2017	0
07.01.2017	0
08.01.2017	0
09.01.2017	0
10.01.2017	0
11.01.2017	0

I can't do this in the script because of the set analysis in the expression, otherwise I would choose the "peek"-Function.

Suppress Null-Values is deactivated everywhere

Thanks for some input 🙂

Hannes

[dsharmaqv]

simple way is

properties>presentation tab>

set Null Symbol to 0 and set the text alignment to right

[malmsteen1977]

Unfortunately not

[tresesco]

Follow this blog post: How to populate a sparsely populated field

[malmsteen1977]

Hi Treseco

I know this posting. As I said in my first posting, I have to do this inside the expression of the diagram, not in the script.

Any other ideas?

[annafuksa1 · Accepted solution]

you need to first create all dates in script and later

[malmsteen1977]

Hi Anna,

the toggle in the Dimensions was the right one 🙂

Many thanks.

[annafuksa1]

No Problem