Can I merge or combine the number of instances an activity type as been used (Tech Issue) rather than every 15 minute interval being counted as one count? E.g If an advisor has Tech Issues 10:00 - 10:30, currently this is being counted as two because there are two ‘15 minute’ intervals in the half hour. I would like the count to be one with the duration time of 30 minutes.
Hi @LParkes and welcome to the QuickSight community!
This may depend a bit on how your dataset is setup. Would you be able to share some additional information, like the fields being utilized and the type of visual you’re trying to create?
Some screenshots may be helpful as well.
1 Like
Hi Brett, thank you for getting back to me.
I’ll send a screenshot of what I currently have. The data shows that Sean had 3 instances of Tech Issue yesterday…however, he actually only had 1 but it was for a duration of 42 minutes meaning it was within 3 within 15 minute intervals.
Ideally, I would like this to only show as 1 instance with the duration time showing as 42 minutes.
Please let me know if you need any further information.