Make Domo Make Sense
Can someone please explain this logic to me, I am so confused.
I am taking some avgs right. Here is my data by day, I have a function to find the max value for the timeframe.
You can't see the rest of my numbers in the screenshot but they are between 197 and 205. As you can see 211 is my max for the month.
If I use the timeframe filter I can switch it from By Day to By Week, also makes sense. Same 211.
But for some reason when I switch to By Month I get a new number that comes out of no where. As you can see from previous photos the max for all of Oct is 211 so where the heck is it getting 223.
The Column Avg Distinct Users is using MAX(count(distinct `User ID`)) OVER()
and Unique Users is using MAX(count(distinct `User ID`)) OVER()
The dataset is a recursive flow of Domostats People.
**If this answer solved your problem be sure to like it and accept it as a solution!
Answers
-
Did you have users get created or removed during the month?
For example if we're at 50 but you removed 5 users and added 5 users
Week 1: 50 users
Week 2: 50 users - 5 removed, 5 added = 50
Week 3: 50 users - 5 removed, 5 added = 50
At the end of the month you'd have 60 different users instead of the 50 you're seeing each week.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@GrantSmith hmm good point, I am sure I am having users added/removed. I guess I was expecting to see that reflect somewhere in the daily number.
**If this answer solved your problem be sure to like it and accept it as a solution!
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 813 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive