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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 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
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive