Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you need to first create all dates in script and later
simple way is
properties>presentation tab>
set Null Symbol to 0 and set the text alignment to right
Unfortunately not
Follow this blog post: How to populate a sparsely populated field
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?
you need to first create all dates in script and later
Hi Anna,
the toggle in the Dimensions was the right one 🙂
Many thanks.
No Problem