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 cons...
Forum Discussion
liamcameron take a look at this Excel screen shot. In the example there is 1 record for green. The difference between the start and end date is 3. Then on your new date table you created (which is filterable by the user) the difference between the selection is 10 days. My understanding is that you want to show 3 / 10 = 30% of the selected time spent on green. Is that correct?
