Why is the time series not showing gaps in data on reports?

If you are using a Time Series with Trans_Date, Sales, Cost and GP columns and using an Area Chart with a Time Series setting and the data is not displaying the gaps in data. 

For example, weekends should show up as zero, but the data incorrectly displays Friday then Monday data. The settings are Time Series ON, Interaction


Dates below show there are 4 days between the 1st and 6th of January yet the chart does not show zeros.

The width of the section that represents the number of days. The narrow highlight represents one day, and the wider highlighted sections represent more than one day, width in proportion to the number of days.

If you change the chart from the Area to Vertical Bar, this will then show "zeros" over a weekend and other days of inactivity.

Version 7.1 build 20140923

Is this article helpful?
0 0 0