Beast mode to calculate month over month user count changes
One of the metrics we calculate as a business is our user change month over month. Our main data set we work off of is an activity log dataset which contains the date of the activity, the user id, and details about the activity. For active users we calculate the distinct number of users for that time period such as the month.
However we would also like to look at the changes in users month over month:
resurrected users - users that had no activity last month but are active this month.
returning users - users that were active last month and this month.
new users - users that have had their first activity this month.
Would it be possible to compare these user arrays using beast mode or would we be able to create a table using Magic ETL somehow?
Comments
-
It would not be possible to define your user states (Is Resurected , is Active etc. in Beast Modes with month over month comparisons in Analyzer. You would have to be presenting the data at the UserID granularity in order to calculate the desired metric (because you'd have to have User in the GROUP BY CLAUSE ...)
INSTEAD what you can do is create a UNIVERSE of Months and User IDs where the granularity is one Row per User per Month since they were added to Domo and then calculate your isResurected, and isActive metrics as binary / boolean columns.
Then you'd be able to cleanly perform your math without having to rely on Count Distinct.
It'll sound like a stretch, but this tutorial: https://www.youtube.com/watch?v=Xb4QgKYgaqg&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=26&t=418s will apply to your use case.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 693 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive