days difference between completed and estimated completion time.

0 votes
Calculate the difference between days that as a blank or a null value in completed date.
May 8 in Tableau by Prakash
8 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
Hi Prakash,

Use ISNULL() or ZN()  to find the blank or null values.

Create a calculated field as -

IF ISNULL([Completed Date]) THEN DATEDIFF('day',[Estimated Date],TODAY())
ELSE DATEDIFF('day',[Completed Date],[Estimated Date])
END

The above code would fetch difference of days wrt completed date or current date(if null/blank).

Hope it helps you.
answered May 8 by CHERUKURI
• 13,940 points

Related Questions In Tableau

+1 vote
1 answer

How can I find the time difference between two columns

Based on the data you showed, I'm ...READ MORE

answered Jul 24, 2018 in Tableau by Atul
• 10,200 points
22 views
0 votes
1 answer

What is the difference between a Bin and a Set?

The fundamental difference between bins and sets ...READ MORE

answered Aug 16, 2018 in Tableau by Naruto
• 710 points
21 views
0 votes
0 answers

How can I add a connection between Mongodb and Tableau

What I want? Parse the XML to JSON ...READ MORE

May 17, 2018 in Tableau by ghost
• 1,790 points
92 views
0 votes
1 answer

How to return the string between 5th and 6th Spaces in a String

In Tableau 9 you can use regular ...READ MORE

answered Jun 26, 2018 in Tableau by Atul
• 5,470 points
28 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,200 points
945 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,200 points
36 views
+2 votes
1 answer
0 votes
1 answer

What is the difference between REGEXP_MATCH() and REGEXP_EXTRACT()?

Hi, REGEXP_MATCH() AND REGEXP_EXTRACT() are both used for ...READ MORE

answered Apr 1 in Tableau by CHERUKURI
• 13,940 points
11 views
0 votes
1 answer

Toggle between a Tableau Worksheet and dashboard

Hi Sindhu, There are different ways of toggling ...READ MORE

answered Mar 11 in Tableau by CHERUKURI
• 13,940 points
44 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.