Awesome! The cartesian product did the trick! Thank you Kettan. However,
I did a cartesian product between my Defect Table and a new table, that has all the end of the month dates. I performed this query between the 2 tables(Custom SQL Query on Tableau)
FROM [Defect] a, [EndOfTheMonth] b
WHERE a.[Detected on Date] <= b.[EOM] and
(a.[Closing Date] > b.[EOM] OR a.[Closing Date] IS NULL)
The end of the month table is structured like this
This almost gave me the result, but when I tried to build this on a tableau sheet, the EOM from the cartesian product wouldn't show me the drilled down values.
Please refer to this screenshot
I don;t know if I am missing a silly logic, or if this is even doable anymore.
1 of 1 people found this helpful
It seems everything in the view is from a secondary data source. It might work if you rebuild the view in a new worksheet so Backlog Cartesian Product (Query... is the primary source.
Awesome! Problem Solved! I appreciate your help Kettan. Thank you very much