9 Replies Latest reply on Feb 4, 2019 12:58 PM by Ken Flerlage

LOD Calculations for Dates?

Greg Barnes Feb 4, 2019 12:01 PM

I am still fairly new to Tableau.

I am trying to calculate how many drivers complete an inspection within 7 days of registering and how many drivers complete an inspection within 7 to 30 days and how many drivers have taken more than 30 days to complete an inspection.

I have tried to do this, so please see Sheet 3 of the attachment

D-Created At - is that date the driver was registered in the system.

R-Created At - is the date on which vehicle inspections were done.

Any advice is appreciated.

CS Data 19.02.04 ii_v10.5.twbx 3.5 MB
CS Data 19.02.04 ii.twbx 3.6 MB

1. Re: LOD Calculations for Dates?

Paul Wachtler Feb 4, 2019 11:11 AM (in response to Greg Barnes)

Hi Greg,

Your calculations seem to be correct. What are you having trouble with exactly? Or are you looking for different ways of visualizing this data?

Best,
Paul
Like Show 0 Likes(0)

Actions
2. Re: LOD Calculations for Dates?

Greg Barnes Feb 4, 2019 11:30 AM (in response to Paul Wachtler)

Paul, I don't think that the numbers in the table are accurate. When I look at the underlying data for August and <=7 Days I see 21 not 7 as shown in the table.
Like Show 0 Likes(0)

Actions
3. Re: LOD Calculations for Dates?

Deepak Rai Feb 4, 2019 11:54 AM (in response to Greg Barnes)

Can you attach 10.5 version of this from File>Export as Version?
Like Show 0 Likes(0)

Actions
4. Re: LOD Calculations for Dates?

Greg Barnes Feb 4, 2019 12:02 PM (in response to Deepak Rai)

Deepak I have attached it to the original post.
Like Show 0 Likes(0)

Actions
5. Re: LOD Calculations for Dates?

Ken Flerlage Feb 4, 2019 12:18 PM (in response to Greg Barnes)
Looks like you're really close. Two recommendations.

First, you need to change the "< 7" to "<= 7" in the CALC Insp Bands field.

Second, I think you want to do COUNT DISTINCT of the D-Id field not CALC Day to First Insp.

See attached

CS Data 19.02.04 ii.twbx 3.5 MB
Like Show 0 Likes(0)

Actions
6. Re: LOD Calculations for Dates?

Deepak Rai Feb 4, 2019 12:26 PM (in response to Greg Barnes)
Here it is:
Thanks
Deepak
If it Helps, Pl Mark it Helpful and CORRECT to Close Thread

CS Data 19.02.04 ii_v10.5.twbx 3.7 MB
Like Show 0 Likes(0)

Actions
7. Re: LOD Calculations for Dates?

Greg Barnes Feb 4, 2019 12:51 PM (in response to Ken Flerlage)

Deepak - thank you for taking the time to answer
Like Show 0 Likes(0)

Actions
8. Re: LOD Calculations for Dates?

Greg Barnes Feb 4, 2019 12:52 PM (in response to Ken Flerlage)

Thank you Ken for taking the time to answer.
Like Show 0 Likes(0)

Actions
9. Re: LOD Calculations for Dates?

Ken Flerlage Feb 4, 2019 12:58 PM (in response to Greg Barnes)

Any time!
Like Show 0 Likes(0)

Actions