- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Show Active Users by month with type 2 table?
I am trying to create a bar chart that shows Active Users by month. The data I have is in a type 2 dimension with Start and End Dates, with the most current row having a null End Date.
What would be the most efficient way to try and show active users by month over a years time, or rolling 12 months so that I don't have to try and hard code dates into the logic or count up the users with some massive if statement.
Thanks in advance for help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sounds like you need the IntervalMatch function.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I thought about that but I guess I'm not completely sure how to apply it or what to use for the expressions and dimensions in the chart.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have a read of Henric's blog post IntervalMatch and give it a go.
If you work with just a small sample of test data, then if you get stuck you can post a question on this forum attaching your qvw.