I've attached a 10.5 workbook for you. Not perfect, but I think it comes close to what you're seeking?
You might have to have some others weigh in on the way the Dates format automatically based on the date selector parameter. I fiddled with it but didn't get far with it but you'll get the gist of it.
Also, some of the percentages are off due to the date/time values being across numerous days and are not shorter periods/segments of time.
I also used the assumption that each "day" was a 9-hour day so the division is based on that for day, week, month, year. If this is helpful, please mark it as such, and if it is correct please mark it as correct.
UsageData_v10.5.twbx 221.8 KB
this might get me on the right path. I appreciate your assistance and input. I had to make some changes in how you were dividing the calculation as I did not specify weekdays only.
So for instance, on the month calculation, you divided by (9*30), whereas the average workdays per month for 2018 is 21.75. So I changed it to (9*21.75). small nuance, but i wanted to share it so you can see the full picture I am going after.
Thank you again for the help and let's see if anyone else has input.