Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to created a bar chart based on month.
Data source for example:
Resolved | Created |
---|---|
17/08/2017 00:27 | 17/08/2017 00:14 |
16/08/2017 18:26 | 16/08/2017 18:18 |
16/09/2017 18:18 | 16/08/2017 19:07 |
16/09/2017 18:18 | 16/08/2017 17:30 |
I want it to be:
As you see for the August, the count Blue Bar should be 4 and Red Bar should be 2 based on the data source.
How do i achieve it based on the month count
I believe you need to use IntervalMatch here and link your master calendar to the two dates in your fact table.