Special Graphics in BO

[juanjoseruiz]

Good Morning from Spain:

I want to do a Circular Graphic in B.O. starting from this table that have a ranking.

Table 1

PROVIDER %Sales
Provider1 50%
Provider2 30%
Provider3 12%
Provider4 11%
Provider5 1%
Provider6 0,5%
...
...

The Graphic that i want is :


Provider1 (50%) -----
/ | \ Others (20%)
| |___
\ / / Provider2 (30%)
-----
My problem is that if i do this graphic in the original table all providers
are here, in the graphic, and i do not want this.

 

[blom0344]

How about defining a grouping variable that creates the 3 groups you need?

Provider 1
Provider 2
Others

Ties Blom

 

[skrandel]

The problem is that it will be dynamic. What if next time the report is run Provider3 is the 2nd highest?

My guess is that the goal is always to display the top 2 and the others. I can't think of a way to do this.

Steve Krandel
Symantec

 

[blom0344]

Yes, you will need an extra bit in the dataprovider.

If the provider data is coming from a non-aggregate SQL, than you can work out a solution using rank() function in the universe:

RANK() OVER (PARTITION BY PROVIDER ORDER BY SALES DESC)

If you use SQL Server than you need version 2005. Earlier versions do not have OLAP functions.

This way the provider with highest sales has rank 1, the second highest sale 2 and the group 'others' 3 and higher.



Ties Blom