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.
Last Modified Date: 23 Dec 2020
Environment
- Tableau Desktop
Answer
Option 1: Use a discrete Date field
- Drag the Date field into [Columns] and set it as discrete MDY.
- 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]
Option 2: Use a continuous Date field
-
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
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials