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
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive