Select to view content in your preferred language

Serial chart in Dashboard behavior has changed

265
1
10-25-2024 05:44 PM
LorettaWinton1
Regular Contributor

Hello,

At some point this summer the serial chart in a dashboard I created has changed from when I built the dashboard. The Serial chart should display the "Top 12 Damage Agents" (out of a couple hundred) in orange if they are a disease, or blue if an insect according to the "Damage Agent Category" (see the image "good dashboard" below). In Data Options I used Grouped values, Category field is Damage Causing Agent, and I split by field "Damage Agent Category" used statistic=count and used 12 as the maximum categories sorted by statistic. 

However, now the maximum categories is missing (so it shows the entire list, not just the 12 with the highest count) and I can no longer sort by count in descending order. They are just all listed alphabetically in a much to long list (see image "bad dashboard" and "Serial chart data options" below). 

Can anybody recommend a way to achieve the desired result?

Thank you!

Lori

0 Kudos
1 Reply
LorettaWinton1
Regular Contributor

Nobody has replied so maybe my description wasn't good. Here is another attempt in hopes that maybe someone will have the solution. Say I survey people in Survey123 about what kind of cheeses they like and I group them into soft and hard cheeses. I want the dashboard to show a bar chart of counts with the 3 most popular cheeses (in descending order) color coded by hard/soft as seen in the screenshot below (created in excel). I used to be able to do this, but sometime after April 2024 I no longer can. Does anybody know how I can do this?  

Thank you and sorry if my initial description was too confusing.

0 Kudos