Hi 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

Hi 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

Hi Stephen,

No worries...glad to have helped ! Don