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, 2019 in Tableau by sindhu
 • 2,172 views

1 answer to this question.

0 votes

Hi,

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

You are calculating average days of difference.

It will work.

answered Apr 1, 2019 by Cherukuri
 • 33,050 points

Related Questions In Tableau

0 votes
1 answer

How to exclude weekend (Sunday only) to DATEDIFF in Tableau?

To exclude Sundays from the DATEDIFF calculation ...READ MORE

answered Jul 3, 2023 in Tableau by anonymous
 • 1,420 points • 3,830 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 • 12,543 views
+2 votes
1 answer

How to Link Dashboard with URL to enable it to open in the same explorer page

Add this to the end of the ...READ MORE

answered Mar 27, 2018 in Tableau by ffdfd
 • 5,550 points • 5,265 views
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 • 3,637 views
+2 votes
1 answer

How can I download tableau workbook with its data from tableau server?

In essence, no. Since the workbook is ...READ MORE

answered Mar 27, 2018 in Tableau by ffdfd
 • 5,550 points • 12,571 views
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
 • 26,740 points • 1,820 views
+1 vote
1 answer

how to print this statement in java print(' '*(r-x-1)+'*'*(2*x+1)) ( logic used in python .its perfect) but java wrong output came

In ' '*(r-x-1) and '*'*(2*x+1), you used multiplication ...READ MORE

answered Dec 22, 2019 in Java by Utsab Bandyopadhyay
 • 2,087 views
0 votes
1 answer

I am not able to install onedrivesdk in linux: it is giving "Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output"

Hi@rose, You are using older version of pip ...READ MORE

answered Apr 20, 2020 in Python by MD
 • 95,460 points • 7,565 views
0 votes
0 answers

strlen() php function giving the wrong length of unicode characters

I want to get the length of ...READ MORE

Jun 20, 2022 in PHP by Kithuzzz
 • 38,000 points • 1,451 views
+4 votes
7 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