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
12 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
3 answers
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
94 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
49 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
62 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
253 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
945 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,815 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
77 views
+2 votes
1 answer