datediff() giving wrong output

0 votes

I want to calculate difference between project deadline and days completed for all teams and for all stages. I'm getting wrong output, what to do?

I gave DATEDIFF('day',[Enddate],[Startdate]) as the code for calculative field.

Apr 1 in Tableau by sindhu
9 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,

Try this, AVG(DATEDIFF('day',[Startdate],[Startdate])) .

You are calculating average days of difference.

It will work.

answered Apr 1 by CHERUKURI
• 13,380 points

Related Questions In Tableau

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
912 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

Bitcoin address SHA256 pipe gives wrong output

You need to hash the raw byte ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 27,620 points
31 views
+4 votes
6 answers

Creating Amazon Web Service (AWS) account (trial version) without giving up credit card details

Unfortunately, you can’t create an account on ...READ MORE

answered Mar 29, 2018 in Cloud Computing by brat_1
• 7,080 points
632 views
0 votes
1 answer
0 votes
4 answers
0 votes
1 answer

How to limit output of a dataframe in R?

For randomly sampling a row/cell where a ...READ MORE

answered Apr 18, 2018 in Data Analytics by kappa3010
• 2,010 points
23 views
0 votes
1 answer

Getting error in Hadoop: Output file already exist

When you executed your code earlier, you ...READ MORE

answered Apr 19, 2018 in Big Data Hadoop by Shubham
• 12,150 points
862 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.