Number of Users who viewed "x" amount of lessons for 3 consecutive months?

Question & Answer
, ,
1

Hi all.

I am looking to calculate the number of users who have viewed at least 20 lessons for 3 or more consecutive months in Quicksight. The dimensions I am using are:

  • User ID
  • View Count (a count of View IDs)
  • View Date
1 Like
2

Hello @Jeff2, you can definitely manage this with a few calculations.

I don’t have the same fields that you do in your dataset, but I made some calculated fields in this Arena analysis that will help you accomplish this task:
Number of Users who viewed “x” amount of lessons for 3 consecutive months?

I was referencing now() and the 2 months previous to now(), but we could also edit that with a parameter value so we could check 3 consecutive months dynamically based on a user’s selection. Let me know if you have any questions about the calculations, or implementing them in your analysis. Thank you!

2 Likes
3

Thank you! I am checking this out

4

Hello @Jeff2, I wanted to check in and see if the calculated fields I shared in the QuickSight Arena analysis guided you towards the desired result. If so please mark my previous response as the solution, otherwise let me know if you have any follow-up questions. Thank you!