Hello friends!
Will you be so kind to help with one issue:
I have standard activity table: CASE_ID, ACTIVITY_NAME, EVENT_TIME
Please find in attachment a sample of table.
I want to make diagram chart (or OLAP Table) to show how many cases are being delivered at a certain month.
For example -
The activity Start of delivery for case #15 takes place on 05.01.2020 and the **next **activity End of delivery takes place on 10.06.2020. That mean that case #15 is being delivered on January, February, March, April, May, June.
The activity Start of delivery for case #16 takes place on 07.01.2020 and the **next ** activity End of delivery takes place on 12.04.2020. That mean that case #16 is being delivered on January, February, March, April.
So the diagram chart (or OLAP TABLE) should show following
Month Case Count
Jan 2
Feb 2
Mar 2
Apr 2
May 1
Jun 1
Will you please clarify which formulas or functions I have to use.
Thank you