Spotfire - sorting Bar chart individually within trellis panels -
could me spotfire issue?
3 data types avalialbe. locations(sting), areas within these locations(string) , sum of hours associated areas , therefore locations.
objective: i'm trying show data value axis: sum of hours, category axis - top 10 areas (sting data). want locations available (trellis location) , sort bars descending in sum of hours, in 1 bar chart visualisation. when did trellis, spotfire trellised original graph, i.e. show top 10 sum of hours distributed throughout locations. not want - want dynamic category axis show me areas of top 10 largest sum of hours per each location.
how do this? idea maybe add custom expression category axis before trellising or add calculated column help, i'm not sure how solve problem. help?
did try 'sort bars value' option ?
Comments
Post a Comment