Count New Ids by time period
Hi Domo,
I would like to calculate new IDs by time period. For example, if there are 100 new ids in the month of September that have not appeared before in any other month, I would like the function to return 100. A simple count distinct will not do, since it counts all distinct values by time period, including returning IDs that are present in previous months. I would like the proposed function to return only the count of new IDs.
Thanks
Best Answer
-
Does your data have a date field that indicates when the ID was added?
If I solved your problem, please select "yes" above
1
Answers
-
You would have to do some work in ETL. I would create a recursive dataflow with a monthly snapshot. Then you could do a join of the current month in one branch and all other historical data in the other branch. Any ID's in the current month branch that don't find a matching ID in the historical data would be new ID's and then you would do a count distinct as you suggested.
If I solved your problem, please select "yes" above
0 -
Thanks, Colemen,
Could you provide an example of what the dataflow would look like? I would like to have the calculation run on all months and keep the data in one dataset. It sounds like a recursive dataflow will only give me one month at a time.
0 -
Does your data have a date field that indicates when the ID was added?
If I solved your problem, please select "yes" above
1 -
Yes, it does, this makes it so much easier. I can just count ids by date added. Thanks Colemen!
1 -
Yes, that makes it much easier! Just date added on the x-axis and then a COUNT(DISTINCT(`id`)) beastmode on the y-axis.
If I solved your problem, please select "yes" above
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive