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
8 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,810 points

Related Questions In Tableau

0 votes
2 answers

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

You can create a set whose dates ...READ MORE

answered 3 days ago in Tableau by anonymous
• 17,870 points
18 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
70 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
36 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
42 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
195 views
0 votes
1 answer

How to combine rows with same information in Tableau

@Ghost, Tableau has a function RANK_UNIQUE which you ...READ MORE

answered May 24, 2018 in Tableau by Atul
• 10,240 points
597 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
1,362 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
50 views
+2 votes
1 answer