
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

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.

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?

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.

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 DId field not CALC Day to First Insp.
See attached

CS Data 19.02.04 ii.twbx 3.5 MB



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

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.

9. Re: LOD Calculations for Dates?
Ken Flerlage Feb 4, 2019 12:58 PM (in response to Greg Barnes)Any time!