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
485 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
2,022 views
+1 vote
4 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
2,965 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 ffdfd
• 5,550 points
1,170 views
0 votes
0 answers

Issues with the Tableau server extracts

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

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

Issues with the Range value in Tableau

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

answered May 9, 2018 in Tableau by ffdfd
• 5,550 points
1,221 views
0 votes
0 answers

Tableau - Issue with .json Format

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

May 24, 2018 in Tableau by ffdfd
• 5,550 points
1,066 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
9,891 views
+2 votes
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
1,594 views
+2 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP