Activity Duration as a % of Total Time | Help and How-To

liamcameron · 2024-05-16T16:22:47.793000Z

I have a dataset with 3 columns: ActivityType StartDate EndDateI’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 recordedso 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:

MoreDiscussions

Activity Duration as a % of Total Time | Help and How-To | Sisense Community