Sep 11, 2024 10:15 AM
Hello! Can anyone help me get some more useful info from this chart?
I want to be able to show a list of breeds with counts in descending order. It seems like its still alphabetical in this legend which doesn't help much. I've also been able to see the counts in a group sort on my member talbe, but I dont see any way to get that info somewhere usefull.
I'm open to creating a new table which would create new lists that show the counts of each breed if that's the best way to do it. Thanks!
Sep 11, 2024 02:13 PM
Hard to say exactly without seeing how your base is composed, but I presume you messed with the "Order" options inside "Categories" under "Data" (there's ascending/descending options there).
I think the donut table may not be your best option here considering how many fields you have. Perhaps a bar graph would display this data more functionally?
Sep 11, 2024 06:35 PM
Yeap, +1 for the "Order" options
Here's my data:
And here's how they look with different orders set:
Default Field Order:
Descending:
Ascending:
---
If you want table where each breed is a single record with the count, you could try converting your current Breed field to a linked field to a new table, resulting in this:
Sep 12, 2024 12:57 PM
Thanks for the insight! I did try the order options, but that is still just alphabetical reversed or not reversed, no?
The linked table you shared looks promising, I will try that. Thanks!
Sep 12, 2024 05:30 PM
Hmm, in the legend on the right with the record counts, they differ based on the order used I think!