Sort Table by Field Count
This one really has me stumped. Please look at the screen shots below. In one card I was somehow able to get the sort to read 'Count of [Field Name]' but in the other, it attempts to sort by the value of that field. I cannot figure out how I was able to get the highlighted aggregation option in my Text sort.
Best Answer
-
Ok ,
So, I think that in a datatable you will only have the aggregation enabled in the sorting section if there is at least one aggregated field (with a calculation other then no aggregation) (even the field in question) in the data table itself.
Hope this helps.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.1
Answers
-
Hi,
You seem to be sorting on a BeastMode, do you have an aggregation function inside that Beastmode (SUM,AVG,COUNT,...) ?
If so DOMO won't let you define a different aggregate in the sorting section.
Hope this helps.Don't hesitate to ask if you need more help on this.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
It's a beast mode concatenation. I'm taking first, middle, and last name and making a full name column. But the odd thing is it's the same field in two different cards, reading off of the same dataset. As you can see in the screenshot, one allows for a 'count of' while the other does not.
0 -
Are the chart types the same?
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
Yes, both are data tables. I'm tracking, by name, the total times a person is seen performing an event. Basically if their name appears, then they are counted. I then want to sort descending by that number. If I can't sort as I am trying, is there a better way to do so?
0 -
Ok ,
So, I think that in a datatable you will only have the aggregation enabled in the sorting section if there is at least one aggregated field (with a calculation other then no aggregation) (even the field in question) in the data table itself.
Hope this helps.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.1 -
@RGranada That was it. Thank you!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 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