Aggregate measures not grouping by Date Field
DomoBeginner
Member
in Charting
Hi Everyone,
I have data at a daily level for every month. I am trying to plot averages (monthly) over time. So for example, if I have 30 rows for June 31 rows for July, I would like to see 2 bar graphs with average metric plotted. Instead, I am getting 30 bars for June with the same average value/bar length and 31 bars for July with the same problem.
Can anyone help me out please?
Thanks in advance!
0
Answers
-
Make sure your date range is set to graph by month and that you don't have the date field in your sorting properties as that will keep it from aggregating properly.
Also, make sure metric is set to Average in the aggregation type.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.3
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 702 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 52 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive