Beast mode calculation based on Time range
I have a data set which consists of two columns - user_Id and visit_date on the site.
the user id remains same for each user i.e if a user login in January for the first time and user_Id 123 is assigned, then for all the subsequent visits on site, the user_id would remain the same irrespective of the visit_Date.
My requirement is calculate no. of new distinct user_id each month i.e How many users logged in a specific month and their records are not present for any previous months data.
For any specific month > Count(DISTINCT(user_ID)) where user_ID not in ( distinct(user_id)) from all prior months to the month in question)
Unfortunately, I could not find a way to build this logic in Beast mode.
Any help on this would be appreciated.
Data Columns available:
user_id , visit_date.
- 10.7K All Categories
- 13 Getting Started in the Community
- 34 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 302 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board