Replace missing dates with 0

0 votes
I have missing dates in my dataset that I am using. So, basically i want to replace the those with '0' so that when i create my line graph , it gets passed through.
Apr 6, 2018 in Tableau by GandalfDwhite
• 1,320 points
28 views

1 answer to this question.

0 votes

Create a calculated field for your dates and use this - 

IF [date]=NULL THEN 0 ELSE [Measure]

This will work for you!

answered Apr 6, 2018 by QueenBee
• 1,820 points

Related Questions In Tableau

0 votes
1 answer

How to replace the count(field) which is missing in data with zero in tableau?

Use calculated field to create a dummy ...READ MORE

answered Dec 21, 2019 in Tableau by sindhu
322 views
+1 vote
3 answers

How to Update my Start and End dates parameter or Filter with Today and Last 5 Days Date Automatically ??

Create a calculated field and set its ...READ MORE

answered Jul 31, 2019 in Tableau by anonymous
538 views
0 votes
1 answer

Creating a calculated field with LOD expression

Go ahead and try the following three ...READ MORE

answered Apr 20, 2018 in Tableau by Atul
• 5,530 points
186 views
0 votes
0 answers

Issues with the Tableau server extracts

A tableau developer had successfully created dashboard ...READ MORE

Apr 20, 2018 in Tableau by Atul
• 10,240 points
95 views
0 votes
1 answer

Issues with the Range value in Tableau

One of the best solution is to ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 5,530 points
167 views
0 votes
0 answers

Tableau - Issue with .json Format

In Tableau Public's documentation, its mentioned that, A ...READ MORE

May 23, 2018 in Tableau by Atul
• 5,530 points
436 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
3,591 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
210 views
+2 votes
1 answer