How to find a max value from multiple aggregates
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.
- 10.7K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board