How to change my legends labels name in Web Intelligence?

building reports webintelligence
1

How to change my legends labels name in Web Intelligence?
I have created a pie chart in Web Intelligence that shows the legend labels for a rating system.

Currently the legends label is showing, 1,2,3,4, and 5. I would like to change this to say 1= Excellent, 2=Above Average, 3=Avergae and etc. I cannot figure out how to make this change. Can someone help me with this. thank you.

I am using Business Objects XI 3.1.
49 minutes ago - 4 days left to answer.

jknox20 (BOB member since 2012-07-09)

2

Quick and dirty way is to create a new Variable in the report based on the Dimension you are using in the Pie Chart which translates the values 1, 2, 3, 4 and 5 into the values you want to use. Then use this new variable in the pie chart.

E.g. Your Dimension returning 1, 2, 3 is called [Result] and you want these to be Excellent, Average, Bad instead.

Create a new Variable called [Pie Label] and make it

=If [Result]=“1” Then “Excellent” Else If [Result]=“2” Then “Average” Else “Bad”

A more complete solution would be altering the Universe to have a similar variable you can reuse or even putting this translation into the database, so the look-up occurs there instead.

DanDensley :uk: (BOB member since 2009-05-12)

3

[Moderator Note: Moved from General Discussion to WebIntelligence XI]

Marek Chladny :slovakia: (BOB member since 2003-11-27)

4

Thank you so much. I did what you told me to do, and I am receiving an error. The error I am receiving is: The expression or sub-expression at position 16 in the ‘=’ function uses an invalid data type. (WIS 10037)

Here is the code I am entering.

=If[Rating No]=“5” Then “Excellent” Else If [Rating No]=“4” Then"Above Average" Else If[Rating No]=“3” Then “Average” Else If[Rating No]=“2” Then “Below Average” Else [Rating No]=“1” Then “Poor”

jknox20 (BOB member since 2012-07-09)

5

Is your [Rating Number] object an integer or a string? If it’s an integer, try taking out the quotation marks around the values (so it would be =If[Rating No]=5 Then “Excellent” Else If [Rating No]=4 Then… etc).

mb

mrsbelley :us: (BOB member since 2010-09-22)

6 

If[Rating No]=5 Then "Excellent" Else If [Rating No]=4 Then"Above Average" Else If[Rating No]=3 Then "Average" Else If[Rating No]=2 Then "Below Average" Else "Poor"

HTH

mockingbird :uk: (BOB member since 2007-02-07)

7

Dan,

I figured it out. I needed to remove the quotations from the numbers. Thanks for your help.

jknox20 (BOB member since 2012-07-09)

8

Mrs.Belly,

Thank you so much. It worked.

jknox20 (BOB member since 2012-07-09)