liamcameron
05-16-2024Cloud Apps
Activity Duration as a % of Total Time
I have a dataset with 3 columns:
ActivityType StartDate EndDate
I’m attempting to build a visual that will report on what % of time is spent on which activity vs another, but I need to consider that not as a percent of all activities, but of all the possible time (assume there will be a time filter). My users want to report on how much of the day had nothing recorded
so I may be wrong, but I created a custom table of every day since 2023:
Then I tried to build a visual, that does a Timespent/TotalTime calculation… to do this I did Sum(Mndiff (enddate, startdate)) / Sum(minddiff (maxdate, minddate))
but I get this error:
Then i've tried using the timestamp... but sitll get this: