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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 730 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive