Complex Sort/Rank

building reports webintelligence
1

Hi,

We have a vertical stacked chart that’s sorted by Year/Month. The chart is displaying the number of complaints by Issue Type, so in each month there can be multiple Issue Types. We want to rank/sort the issue types within each Year/Month combination based on the Total for the past 12 months. So, if Issue Type “Bad Code” has a total of 120 complaints over the past 12 months and is the top issue type, “Bad Code” should be #1 in the stacked chart for each of the 12 months. If issue type “missing tables” has the lowest complaints for the first 2 months but has 115 complaints for the year, it should still be displayed 2nd in each of the 12 months.

Does this make sense and is it possible in WEBI XI 3.0?

Thank you!
Kevin

kvangor :us: (BOB member since 2003-03-20)

2

Hi,

I found a solution. I created a new variable using the RANK function by Issue Type and Complaints. I inserted the new variable in the chart and sorted on the variable to get the results the users are looking for.

Thank you!
Kevin

kvangor :us: (BOB member since 2003-03-20)