Partition By Beast Mode as a Filter
I created this Max('Value') that is grouped by a certain NamingKey using the Partition By.
I followed the syntax recommended by DOMO in the attached image.
I was able to get Max and Min values and use them within a Case statement, but I could not filter from that Case Statement.
The Partition By Beast Modes just don't populate as filters. Do I need to go through MagicETL? Thanks.
Comments
-
You cannot use aggregate beast modes as filters as documented HERE.
You're correct that MagicETL or a MySQL dataflow could achieve this so that you can filter. The MySQL dataflow syntax should be similar or the same.
This MySQL dataflow I thought would do the trick but I'm getting an error: Source example: https://database.guide/max-find-the-maximum-value-in-a-column-in-mysql/
SELECT
`value`
,`series column`
,MAX(`value`) OVER(PARTITION BY `series column`) as 'MaxInSeries'
FROM `dojohelppartitionover`Even the MySQL documentation found HERE claims this is how you would do it, maybe it's just my data or something buggy for me? Can you try and let me know?
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive