Ranking in Pie Chart

[system]

HI

I am using Bo 3.1 with Oracle as backend…

I am trying to do a ranking on pie chart… searched the forum…but the solution given in the forum is now working for me…

120×120 10.4 KB

Lets say I have 100 counties in a dimension object and census in a measure. I want to build a pie chart that shows the Top 10 counties by census, which is easy to do with adding a rank on the pie. Doing that doesn’t look right however, because the slices are sized based on the census of those 10 counties only. Therefore, I want to add an 11th slice with “Other Counties” so the Top 10 are proportional to the entire pie/census. I tried adding a dimension object: IF(rank([county];[census]) <=…

120×120 10.4 KB

Hi all, we are facing a challenge using Web Intelligence XIR2 when trying to achieve the following customer requirement: We have a list like the one below: A 30 B 15 C 40 D 41 E 20 We need a ranking for the TOP 3 (D,C,A) but we also want to show a grouped row called OTHERS with the amount for the rest of Dimensions which are excluded from the top 3. In this example above, we should need the Table / Pie Chart as Follows: D 41 C 40 A 30 OTHERS 35 We’ve tried using context…

I have data…

Region   Prod    Sale    Rnk
------------------------------------------
North      A         30       3
North      B         35       1
North      C         20       4
North      B         32       2

West       A         30       1
West       B         20       2
West       E         15       4
West       F         18       3
---------------------------------------

Now i have to make a pie chart and show TOp3 Prod sales %. I can filter region make 2 pie charts one for North and one for West. if the sales is not 100% then show the slice as others.

The problem is I am not able to do ranking… I am making pie using Prod and sales… but how can i do the ranking… I also added a column Rnk in the table…but not able to use it… as pie only uses one measure.

Please advise

Thanks

---

rajx72 (BOB member since 2006-08-02)