Partition in Beastmode
I'm hoping someone may be able to help me understand what I am doing wrong with my beastmode logic, or if what I am trying to do is just not possible in beast mode.
I have done rank and windows in ETL before, but I am trying to avoid creating a separate dataset.
I'm wanting to filter my card to locations, by day, that had 10 or less registered donations. Each donation is given a completely unique number called a donation id. By necessity, there are multiple rows with the same donation id in our data. So, normally when I want a count of donations, so as not to double count the same value, I just use the count (distinct donation id) beast mode. But, since I am wanting to narrow down to locations with 10 or less donations ids, and since you cannot put the distinct count in a filter, I was hoping to accomplish this with a type of rank/partition concept. I've had success with this type of scenario using Rank/Window in ETL in the past, but I was hoping to accomplish this same concept in a beastmode. I know that the Partition in the beastmode is not supported by DOMO, so maybe this isnt possible.
Here is my beastmode:
rank( `lte_donation_general.donation_id`) over (partition by `lte_donation_general.collection_date`,`lte_tbl_calendar.location_name_tzw`,`lte_donation_general.donation_id`)
What it is doing for me, though, is that it is counting the occurences of each donation id per date/location combination
I have attached an example
- 10.7K All Categories
- 13 Getting Started in the Community
- 37 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board