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
- 4 Connect
- 914 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 77 Cards, Dashboards, Stories
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive