Show Top N Bars in Stacked Bar Chart
When using the "Show Top Items" feature with a stacked bar chart (Properties menu > Show/Hide Items), the limiting of items is based on the number of bar segments, not the entire bar values. This is described at the bottom of this reference guide: https://docs.tibco.com/pub/sfire-bauthor/7.8.0/doc/html/en-US/GUID-E241BEAD-961B-475B-83EF-E82A8D544827.html
I have a scenario where I need the user to be able to specify how many bars they want to see. I have a property control where they can input a number, and that number feeds into the Show/Hide Items setting. The issue is that I want to show the top N items based on the entire bar value, not the bar segments. The default behavior produces some results that are not intuitive, e.g. the user will say "show me the top 5 items" and Spotfire will only show two bars, because it is counting 5 bar segments. Is there a way to modify this to show the top N items based on the entire bar value?