Hi @RonGros , is your data denormalized? If it is denormalized, I.E each row represents one time
one person
watched one movie
, you can easily bucket by date in Lens, then unique count of name
would be the number of people who saw a movie in that time period. If you're calculating an average, you'd need to calculate it over multiple buckets, whereas a graph would show a value per bucket, so I'm not exactly sure what the average you're looking for is.