group by and sorting by date
I have daily data (years of it) that will be grouped by category (columns summed by group), but also need it to happen within different date ranges. Last week, MTD, QTD, YTD etc. The only way I can think to do this is maybe in the ETL creating a new column with case statements for each category/date possibility, but this seems excessive and would not allow me to adjust date within the card later. Is there a better approach?
Best Answer
-
Depending on how your data is organized, you should be able to do this within the card itself. If you use the date as a column/axis, then you can just do sums of all the columns you add and Domo will do all the grouping for you. This will also let you do all the custom filtering and timeframes you want.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2
Answers
-
Depending on how your data is organized, you should be able to do this within the card itself. If you use the date as a column/axis, then you can just do sums of all the columns you add and Domo will do all the grouping for you. This will also let you do all the custom filtering and timeframes you want.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2 -
@RobSomers Yes, thank you. I was previously attempting to do a sum in beastmode, but by doing a sum in the aggregation it does automatically group it.
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 561 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive