Cant sort on a specific column suing rank and custom function

when I create a calculated field using this formula and this is created as Ranking
CASE WHEN
RANK() OVER (PARTITION BY SUB_CATEGORY_TXT
ORDER BY SUM(SALES_LC_AMT
) DESC) >=6 THEN 1000
ELSE RANK() OVER (PARTITION BY SUB_CATEGORY_TXT
ORDER BY SUM(SALES_LC_AMT
) DESC)
END
now when I drag and drop Ranking to filtering, it says "An issue has occurred during processing. We are unable to complete the request at this time.
"
Best Answer
-
When you add a window function to the filter section, you will need to make sure that you partition by everything that is getting partitioned in the table or graph. For example, it looks like you have two fields, "SUB_CATEGORY_TXT" and "Manufacturers" in the table, but you are only partitioning your calculated field by the former. Try partitioning by both fields and see if that helps.
0
Answers
-
When you add a window function to the filter section, you will need to make sure that you partition by everything that is getting partitioned in the table or graph. For example, it looks like you have two fields, "SUB_CATEGORY_TXT" and "Manufacturers" in the table, but you are only partitioning your calculated field by the former. Try partitioning by both fields and see if that helps.
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 306 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 787 Beast Mode
- 78 App Studio
- 43 Variables
- 742 Automate
- 187 Apps
- 474 APIs & Domo Developer
- 67 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive