Sum timelog time by user after grouping into folders
I'm using the time spent timelog time spent function to get the total time logged for a user separated by 5 folders below. In addition to this, I would like to be able to sum all 5 of these folders for a grand total of logged time.
If possible, I would like to then get a ratio of how much time was spent by folder compared to their total logged time (for example, a user logged 100 hours in | US Time Off out of their grand total 1000 logged hours, so it would show 10%)
Hi Caitlin Gubert,
I think you cannot achieve your goal, because each column and raw applies filters to data.
Maybe you can try to use ALL function
But I think it cannot work.