BusinessObjects Board

SAP Dashboards 4.0

other Xcelsius - Crystal Dashboard Design
#1

Hi Experts,

I am having a scorecard and want to align the column values in the center it works fine but when I apply alerts it is not aligning to the center looks like some space is is occupied in the front. :hb:

I am struggling to bring the coulm values to center with Alerts enabled.

Please let me know your suggesstions on this, Thanks for your help in advance as always

Thank you!
Sangeetha

Sakhethram (BOB member since 2012-02-08)

#2

are you using the text and alerts in the same column…?

Naveen.SAP (BOB member since 2012-11-16)

#3

Hi,

Thanks for your response.

I am not using text and the datatype for my coulm is number, My requirement is if the value equal to 0 than show the cell as grey shaded and the rest with no color.

In the Alerts Values :
By Value : I am binding the cell with formula if (B1<=0, 30,70)

Alerts Thersholds :

Minimum to 30 is grey color binded
30 to 70 is white color binded

Enalbe auto color is unchecked.

Hope this helps and Thanks again for your response

Thank you!
Sangeetha

Sakhethram (BOB member since 2012-02-08)

#4

Hello Sangeetha,

Go to the “alerts” section of the scorecard.
Check the box to enable the alerts for which ever columns you need.

Specify the minimum and maximum values and give the color you need.
In the “Alert Thresholds” section you will find 2 types of alerts.

The left side alert places an arrow or a traffic light or any other symbol in the column, and the right side alert changes the color of the cell.

For your req, you need to change the alerts on the right side so that you can change the color of the cell.

Naveen.SAP (BOB member since 2012-11-16)

#5

Hello Stag,

Thanks much for your response, as you said I was making the left alerts as No Icon but the From checkbox was on so it occupied the space

Alerts Threshold : When I take out the From checkbox I could able to see the alignment as expected.

Your help is much appreciated :). Thanks again

Sangeetha

Sakhethram (BOB member since 2012-02-08)

#6

Cool. You are welcome. Let me know if you need anything else

Naveen.SAP (BOB member since 2012-11-16)

#7

Hi Stag,

Thanks for your response.I am trying to built in a Gnatt chart in Dashboard 4.0 since we don’t have any inbuilt Gnatt chart available in dashboards version.

I am trying to bring in through stacked bar chart and try to make the first series invisible by changing the colour to white but not able to get it fully done the bar is shown in white color.

I try to change the transperancy and it is getting for all the series not for a single series :frowning:

Please let me know your thoughts on this

Thank you!
Sangeetha

Sakhethram (BOB member since 2012-02-08)

#8

Hi Sangeetha,

Did you try using a waterfall chart.?
I know that the waterfall chart gives you a set of vertical bars, but this is the closest direct way to achieve your requirement.

Naveen.SAP (BOB member since 2012-11-16)

#9

Hi,

Can anyone help me on the following items :
Waterfall Chart :

I tried to use the Waterfall chart but we can add only one series in waterfall chart. In my requirement I need to plot two series of data.

Also when I try to add a manual axis for date it is not taking properly.

Line Chart : It allows as to plot two series but Is it possible to have custom shapes as we have in excel? so that we can try to plot it as _____ instead of circle or other shapes

Thank you!
Sangeetha

Sakhethram (BOB member since 2012-02-08)