Is there any row_number or rank function in beast mode?
Best Answer
-
Hello @user00614!
Currently at this time, these functions are not available in a BeastMode. However, they can be done in an ETL Dataflow, or using a MySQL Dataflow, though I recommend the ETL Dataflow because there are less steps involved than using MySQL.
Here is an article from our Knowledge Base on the ETL Dataflow Rank and Window: https://knowledge.domo.com?cid=etlactionsrankandwindow
Thor
**Say 'Thanks' by clicking the heart in the post that helped you**
**Please mark the post that solves your question as 'Accepted Solution’**
**Say 'Thanks' by clicking the heart in the post that helped you**
**Please mark the post that solves your question as 'Accepted Solution’**2
Answers
-
Is anyone able to help out with this request?
0 -
Hello @user00614!
Currently at this time, these functions are not available in a BeastMode. However, they can be done in an ETL Dataflow, or using a MySQL Dataflow, though I recommend the ETL Dataflow because there are less steps involved than using MySQL.
Here is an article from our Knowledge Base on the ETL Dataflow Rank and Window: https://knowledge.domo.com?cid=etlactionsrankandwindow
Thor
**Say 'Thanks' by clicking the heart in the post that helped you**
**Please mark the post that solves your question as 'Accepted Solution’**
**Say 'Thanks' by clicking the heart in the post that helped you**
**Please mark the post that solves your question as 'Accepted Solution’**2 -
Thanks for the reply. I noticed that in ETL data flow. Even I can do the same in our server etl where I am using a staging DB. I can just add a new column. It was just my thought that wouldnt be a row_number or rank group by stuff can be very relevant in beast mode?
1 -
I think it would be a great Enhancement Request for our BeastMode functionality. You can let our Product team know about this by submitting Feedback using the Feedback button inside of your Domo Main Menu.
Also, here is a link to our FAQ concerning Enhancement Request processing, and how to submit feedback inside of Domo: https://knowledge.domo.com?cid=faqs
You are also able to create suggestions in the Domo Dojo here: https://dojo.domo.com/t5/Ideas-Please-suggest-ideas-to/idb-p/Ideas. In this section of the Dojo, customer suggestions can be "liked" by other customers, and updates will be intermittently provided about whether something will be implemented, and if so, when.
Our product team reviews every enhancement request submitted.
**Say 'Thanks' by clicking the heart in the post that helped you**
**Please mark the post that solves your question as 'Accepted Solution’**0 -
I am actually looking to use this feature in Beast Mode because I need it to be dynamic. I need to rank to update, as filtering occurs. I don't think this would be possible with the ETL.
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"6 -
Would appreciate if there is any update on this? For dynamic ranking for Beast mode?
1 -
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive