I am looking for assistance to show cumulative duration based on quarter selection.

[leroy773]

I am looking assistance to calculate cumulative total based on quarters I select.  I currently have a table where the cumulative number of days is calculated, but when I graph it shows the cumulative days when the serial number is installed.  My relationship has date installed related to my date key.  When I graph with quarters and years, it shows the total time installed in Q1 for serial numbers installed in Q1.  I would like this time spread out over the quarters instead of summing the total and placing it solely in Q1.  This duration should be spread out over all quarters.  Any guidance would be appreciated

Serial Number	Date Installed	Time Installed
1	1/15/2019	1150.00
2	1/9/2019	1156.00
3	1/24/2019	1141.00
4	1/25/2019	1140.00
5	1/16/2019	1149.00
6	3/6/2019	1100.00
7	4/29/2019	1046.00
8	4/29/2019	1046.00
9	4/25/2019	1050.00
10	4/24/2019	1051.00
11	5/8/2019	1037.00
12	4/24/2019	1051.00
13	5/8/2019	1037.00
14	5/15/2019	1030.00
15	5/15/2019	1030.00
16	5/13/2019	1032.00
17	5/14/2019	1031.00
18	5/16/2019	1029.00
19	5/20/2019	1025.00

[vojtechsima]

Hi, @leroy773,
could you please share a picture with the result I am not sure about the final product?

[leroy773]

In the chart below as an example, Q1 shows the total time a that 6 instruments were installed.  So Q1 shows 6836 days, but those 6836 days should be spread across all the qtrs from Q1 2019 to Q1 2022.  So ideally those days would be approximately 546 days in each quarter and not lumped into the quarter the instruments were installed.  Thanks,

[v-yanjiang-msft]

Hi @leroy773 ,

Sorry still not very clear about your problem, which columns are in the chart and what's your formula? could you please provide more detailed explaination.

Best Regards,
Community Support Team _ kalyj