Always Show Last 24 Hours on Line Chart When Data Starts with NULLS
I am making a line chart on a continous time-based axis. I am using the relative time filter to show only the data in the last 24 houts. When the range starts with NULL values, my x-axis does not go back the full 24 hours. Instead, it only goes back to the first value and starts the chart from there. For example, if I have 3 hours of NULL values to start my last 24 houts, then the x-axis only shows the last 21 hours. How can I make the x-axis always show the full 24 hours even if the daa occasionally starts with NULL values? I have selected the option to "show items with no data" but that didn't do anything.
Thank you for this information. The new measure converts all the NULLS to zeros and then puts the zeros on the chart. This does extend the x-axis to the full 24 hours but now it shows zeros on the line chart. Is there another way to show the full 24 hours on the x-axis but leave the NULL values as missing on the chart and tooltip? I don't want to give the impression that an actual zero value is in the data, but instead show the values as missing (gap).