I want to find the average number of unique days a specific group of users (a saved cohort) viewed a particular widget (filtered by widget_id) within a given time period (e.g., last 30 days).
For example: I have a cohort of 50 users. I want to know — on average, how many unique days did each user in this cohort trigger the event Viewed Widget where widget_id = 5443?
So if User A viewed it on 3 days and User B viewed it on 5 days, the answer should be 4 avg unique days.
I tried:
Frequency Distribution in Insights — doesn't give unique days
Frequency per User → Average — gives event count not unique days
Aggregate Property — doesn't have a date-based unique count
