How to find a max value from multiple aggregates
Hey guys,
I'm looking at our collections information from the last two years to find our best collections month during that time frame for each of our locations. Before when I had to do this I just did it in ETL using a group by function, but this case is a little more complicated as I'm wanting a specific set of collections as opposed to all collections.
Basically I have a column dedicated to the string "collections type" which is tied to the other number column "collections amount". When I try to filter the "collections type" column and then group by "location" and "date" the ETL throws out an empty data set.
Is there an easier way to sum up all collections of a certain type by month? Once I have that information correct I can just do the max function over the date time frame I want to look at.
Best Answer
-
Can you just use additional segments in your group by to include the month and collection type?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Can you just use additional segments in your group by to include the month and collection type?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
No, I found the problem. I need to have multiple filters as I was also filtering by dates. Thanks for the suggestion though, I appreciate you responding.
0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 257 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 501 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 378 Beast Mode
- 20 Variables
- 486 Automate
- 104 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 317 Distribute
- 65 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 64 Community Announcements
- 4.8K Archive