-
1. Re: TIME Series LOD Help
Don WiseNov 17, 2018 10:20 AM (in response to Stephen Groff)
1 of 1 people found this helpfulHi Stephen,
I think what you're likely going to have to do is provide an independent set of consecutive dates, using a separate data source such as MS-Excel or other fact table of dates; then, perform what's known as 'Date Scaffolding' using a Cartesian join to capture the correct number of closed cards and the correct number of initiated cards by whatever date value (months) you're binning to.
Instead of using your Start Date, you'll use the new Calendar Date for your bar chart on columns, along with the related calculation from the thread in a filter to count everything between Start and Finish dates, to get the correct numbers.
Please see this thread: Date Difference by Month for Contract Days or this thread: How do I use 'start date' and 'end date' as examples.
Hope it helps! Thx, Don
-
2. Re: TIME Series LOD Help
Stephen Groff Nov 17, 2018 10:23 AM (in response to Don Wise)1 of 1 people found this helpfulTHANK YOU!!!
I appreciate the time you took to reply. There are several challenges with the data set regarding the available dates. I will deep dive into your suggestions.
Thanks again!
-
3. Re: TIME Series LOD Help
Cédric Tran Nov 17, 2018 10:30 AM (in response to Stephen Groff)1 of 1 people found this helpfulHi Stephen,
Here is my contribution:
MIN(
IF DATETRUNC('month', [Start Date - Actual]) = DATETRUNC('month', [Finish Date - Actual])
THEN { FIXED DATETRUNC('month', [Finish Date - Actual]) : COUNTD([Idea ID]) }
END
)
Please find all the explanation here : https://kb.tableau.com/articles/howto/combining-start-and-end-dates-into-a-single-axis
Cedric
-
4. Re: TIME Series LOD Help
Don WiseNov 17, 2018 10:31 AM (in response to Stephen Groff)
1 of 1 people found this helpfulHi Stephen,
No worries...glad to have helped ! Don