- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Chart to show all horizontal (x) axis values even when there's no data
I have a chart with a time-variable on the horizontal axis which is loaded from the a time/date table (which is loaded independent of any data). I want the horizontal axis show all the values within the time range but the chart is not showing one period because there is no data. Instead of showing a gap, It just ignores this timepoint.
Why, and how can it be corrected? I have enabled "show null-values". As mentioned: the timetable is completely loaded, no period is missing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For the x-axis do you have the data? If not, that is expected because for the period you want to see there is no data associated from your source.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, for the x-axis I have the data. Every possible period is in the table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
are you sure that the value in x-axis is not coming? sometimes due to compress objects it may be hidden. Try to use filter pane for that field and select where you see the gap and see if chart is displaying anything to that?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I was suggested to add a measure to the chart to force the chart to show this month:
=Count({1<DCA_IsoJaarWeek={">=$(=((Year(Today())-2)*100)+week(today()))<=$(=((Year(Today())*100)+week(Today())-1))"}>} Distinct(DCA_Dag))-7
this results in this chart snippet:
So actually, there's no data as shown by this line.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please share us the sample file to have a look on this.