Could you attach sample data as twbx and illustrate problem and expected results?
Not entirely sure if this is what you're looking for, but let me give it a try. I mocked up a sample data set as follows:
Date Value 1/1/2018 89 2/16/2018 71 4/3/2018 96 5/19/2018 73 7/4/2018 58 8/19/2018 77 10/4/2018 60 11/19/2018 52
There are a few ways to visualize this data. Typically, this type of information would be visualized using a line chart as follows:
If you Date field is continuous, then the chart will automatically include all the dates along the axis (though it will only plot those dates with data).
But, based on you question, I'm guessing that you want something a different--perhaps something that simply plots every day like this:
If this is what you're looking for, then you can right-click on the Date pill and choose "Show Missing Values". That will then show all of the dates as shown below:
It'll show NULLs in each missing date. If you want to change these to zeros then you can double click on the pill on the text card and add "ZN(" to the beginning and ")" to the end.
This will convert the NULLs to zeros.
See attached workbook.
Missing Dates.twbx 22.2 KB
Just following up.
If you have further questions, please reply to this.
If you think problem is solved, please mark answer as correct / helped to close the thread not from inbox but from originals post.