How can prevent aggregation when graph by quarter
Hi I would like to visualize the count of customers by month or by quarter.
the data is monthly, so when I graph by month it gives me the correct sum(count).
However when I graph by quarter, the sum(count) of each month within a quarter are summed up, which is not correct. The number of customers at end of Q1 should be the same number of customers at the end of March, not the sum of January through March.
Thank for your help!
Answers
-
Dali did you want COUNT(DISTINCT) instead of COUNT?
If so, you cannot COUNT DISTINCT across rows in a table card or graph.
You might UNION a dataset to your dataset of just distinct customers.
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"2 -
Thanks Jae - You point makes sense.
I also realize that my use case is complicated by the fact that I have slicers within the data that Domo gets confused on how to aggregate.
if I didn't have filters/slicers/series, I would just need to make sure the measure has no aggregation (this is the solution for my simpler use case). In that case, I can graph by Month or Query without having the month counts being summed up.
I was also told about dynamic segmentation, that I am yet to explore.
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive