Hi, I need help to visualize data on a time series chart the way I want. I have a per day time series chart, but the dataset I provide does not have a value for every time bucket (day). For the days with missing values, the chart does not visualize any marker (of course) and it displays a line connecting the markers of the two nearst days with some values. This gives the idea that during the days with missing data the value is a linear interpolation of the previous and next values. In my case, the value for all the missing days is supposed to be 0, which gives a very different chart. Is there a way to instruct the chart to use zero for days with no values? Is there a way (SQL?) to "complete" the dataset with missing days, assigning 0 as value? Could you please give me some advice on how to obtain the result I need? Thanks in advance IlBalla
