Crossfiltering Snap-shot fact table with Transition fact table

[epresson]

Hello,

I have a data model as such:

dim_date=daily calendar table

dim_bug=dimension table

fact_bug= daily snap shot fact table

fact_bug_actionability=transition fact table

fact bug contains data like so:

Calendar date	ID	Severity	Priority
1/1/2020	1	Major	High
1/2/2020	1	Major	Medium
1/1/2020	2	Minor	Low
1/2/2020	2	Major	Low

fact_bug_actionability contians data like so:

Modified Date	ID	Due Date	Action
1/25/2020	1	5/1/2020	Employee
2/20/2020	1	5/1/2020	Manager
1/2/2020	2	3/1/2020	Employee
3/2/2020	2	5/1/2020	Employee

I need to count the number of rows in fact_bug which have IDs with fact_bug[Severity]=Major, fact_bug[Priority]=High, and where fact_bug_actionability[Action]=Employee all by date.

My problem is that I can't get a running total of the count by date since the fact_bug_actionability table does not have a daily granularity. So my line chart ends up showing something like this:

What I want is a running total of the count. Anyone have suggestions?

[lbendlin]

Create a second, disconnected Dates table to fill in the gaps.  Then you can create a cartesian measure for your running total.

[epresson]

@lbendlin , I don't think I can use a disconnected date table as I need a common date axis in my chart for a bunch of other measures I also use on the same chart. I need all of the measures to be charted on the same date axis from my dim_date table.