Hi, in visuals I have the ability to show/hide the other category. Is there anyway to customise this category name to something else, for example if I wanted to call ‘Other’ as ‘Other answers’.
The reason I’m asking is that this is currently confusing to our users, we have a chart showing survey results and one of the answers is ‘Other’. So I have two groups in the chart both called ‘Other’, one for the actual answer ‘Other’ and another for all of the other values which have been grouped together due to datapoint limitations.
Hello @jonnyp, welcome to the Quick Sight Community!
I see, so you have a field name value that is called “Other” and you have exceeded the number of groups available in the visual so Quick Sight is return the default value of “Other” for remaining fields, am I correct?
I did some testing on this to double check, but there is not currently a way to change that default name when Quick Sight creates the Other category. Depending on the visual type that you are using, you can edit the visual and increase the number of categories or rows you want to display. You might be able to adjust and show all of them to eliminate the confusion. Let me know if that helps!
Hey Dylan, yes that is correct. Thanks for checking, I’m aware that I can increase the number of groups but in this particular case there are lots of answers and so increasing the number of groups isn’t practical as the donut chart I’m using gets increasingly unreadable.
Hoping there is a customisation feature available in the future to rename this field similar to how you can provide custom NULL formatting.
Do you happen to know how I can request this as a PFR on the community?
Hello @jonnyp, we tag the tickets as a feature-request which then get reviewed by the Quick Sight team. One thought I had is what if you used a rank or denseRank function to number your categories. Then you could set up a parameter called top 50% and bottom 50%.
If the number of categories are static, you can split the number (Greater than 50, less than or equal to 50). If the categories are dynamic, you can divide the category rank by the total number of categories. The one thing to remember is these will match opposite to the category (Rank 1 will be lowest percent, lowest right will be highest).
Then in a calculated field write an ifelse statement like this: Option 1 = ifelse(${groupParameter} = "Top 50%" AND {rank} <= 50 , {categoryName}, ${groupParameter} = "Bottom 50%" AND {rank} > 50, {categoryName}, NULL)
Oh, and 1 final option would be to simply use the rank and display the exact number of categories accepted, and provide your alternate name for the remaining. So if you can show 250 categories, do this: Option 3 = ifelse({rank} <= 249, {categoryName}, "Other answers")
That last one may be closest to the original ask, but the other 2 will allow the user to view all options. I will mark this as a solution for now, but if you have any questions please let me know! I will also leave the original question marked as a feature request for review.
Hi Dylan, thanks for taking the time to write out these two solutions. I don’t think either is perfect for my particular use case, it really would be great to have a custom ‘other’ category.
I will mark this as the solution though as they are both great options for doing this. Thanks!