Grouping data by month in table

Can someone advise on how I can create a table which groups the data so it is one month for each row? I tried Group by and it just formats the date column fields to the month-year. But continues to track each individual date separately.
Best Answer
-
It's grouping based on all non-aggregated fields. Because you're not aggregating the NumberDelivered field it's including it in the grouping. If you aggregate it with Sum it should remove the duplicate SendDate fields and aggregate it for the entire month.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
It's grouping based on all non-aggregated fields. Because you're not aggregating the NumberDelivered field it's including it in the grouping. If you aggregate it with Sum it should remove the duplicate SendDate fields and aggregate it for the entire month.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive