create a card to display a number ranking
can anyone point me in the right direction on how to create a card with a number ranking that will auto update? we give the sales people a score based on their activities. the one card will put them in order based off their activity score total. how do I create a separate card to just populate their Activity Score Rank? (i.e. 1st 2nd 3rd 4th 5th or 6th) the card I have now, I have to manually update. looking to automate it
Best Answer
-
@ScottLeeds You need to use two aggregations for this to work.
SUM(SUM(1)) over….
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Answers
-
You can use a window function for something like this:
SUM(SUM(1)) OVER (ORDER BY `Score` DESC)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I hope I'm saying this correctly. The column I'm trying to use is a beast mode so it's not showing as an option. To put in the actual column name instead of the `Score` example you gave.
0 -
@ScottLeeds you can copy the score beast mode and paste it into Grant's formula.
sum(1) over (order by (paste your beastmode here enclosed in parenthesis))
Also, make sure you have card interactions set up on the lead card so that the rank card knows to update with the salesman clicked on in that card.
0 -
You probably want:
sum(1) over (order by (beast mode formula)desc)
otherwise it will rank the lowest score 1st rather than last.
0 -
@jessdoe now it just populates whatever number I put in the parenthesis after sum
0 -
@ScottLeeds if you aggregate the sum again as in Grant's formula does that give you your rank back?
sum(sum(1)) over (order by (beast mode formula)desc)
0 -
@jessdoe that didn't work either
0 -
Can you paste your beastmode @ScottLeeds
0 -
0
-
@ScottLeeds You need to use two aggregations for this to work.
SUM(SUM(1)) over….
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive