Question
How to show 0 in the step line graph when there is no data.
For example, for a series of data from 12/1 ~ 12/6 without data in 12/4 and 12/5, how to show 0 in the step line graph for 12/4 and 12/5.
How to show 0 in the step line graph when there is no data.
For example, for a series of data from 12/1 ~ 12/6 without data in 12/4 and 12/5, how to show 0 in the step line graph for 12/4 and 12/5.
Drag the Date field into [Columns] and set it as continuous Day.
Right-click the Date date ad select [Show Missing Values] in the drop-down menu.
Create a calculation field for showing 0 when there is no data as ZN(SUM([Value]))
Drag the newly created value field to [Rows]
Right-click the value field and select [Edit Table Calculation]
Set the table calculation as below