How can I sort the items in Insight Visual in Quicksight?
Customize Narrative:
For Bottom.[items]**
Bottom.items[index].categoryValue.formattedValue** with Bottom.items[index].metricValue.formattedValue
I don’t need to have the value for the years to be ascending. but no chimneys & unknown stay as last two
Please advice, thank you!
Hi @Jane,
Could you explain what you’re trying to accomplish a bit more in depth? Are the values populating next to the year values incorrect?
Insight visuals do not have the same sorting properties like the other visuals, they more or less portray the information you add in. So if you’re looking to setup a custom sort, I would suggest building a calculated field that handles the ranking so that you can use within your narrative.
I am trying to sort them by
and the custom range is written in calculated field:
ifelse(
A >= 1990 AND A <= 2000, "2000 & Prior",
A > 2000 AND A <= 2010, "2001 - 2010",
A > 2010 AND A <= 2020, "2011 - 2020",
A > 2010 AND A <= 2020, "2011 - 2020",
A > 2020, "2021 & After",
B = "No Chimneys", "No Chimneys",
"Unknown"
)
Hi @Jane,
Apologies for missing your last response; since these values have been created with an ifelse, it may be difficult to setup a ranking of these ahead of time. Within your narrative though, you should be able to edit the index number, which will allow you to customize the order:
Hi @Jane
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @Jane
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!
