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!
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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 83 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 179 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive