Help with a chart expression

[Anonymous]

Assuming I have the following table:

Activity ID	Date	Time Period	% of the day occupied
1	01.01.2018	10-14	50%
2	01.01.2018	10-14	50%
3	01.01.2018	10-14	50%
4	02.01.2018	10-14	50%
5	02.01.2018	10-14	50%
7	02.01.2018	14-18	50%
8	02.01.2018	14-18	50%

I need an expression that calculates the amount of days worked by summing the "% of the day occupied" for each date and time period.
Given the above table, the result of the expression should be 1.5 days/150%(any format works for me as long as the results are good)(50% on 01.01.2018 ,in the 10-14 time period, + 50% on 02.01.2018 ,in 10-14 time period, + 50% on 02.01.2018 ,in 14-18 time period)

[sunny_talwar · Accepted solution]

May be this

Sum(Aggr(Sum(DISTINCT [% of the day occupied]), Date, [Time Period]))

[Anonymous]

That's it, thanks!