Eclipse Community Forums: BIRT » Conditional Labels for Value (Y) series

Help

Home

Home » Eclipse Projects » BIRT » Conditional Labels for Value (Y) series

Show: Today's Messages :: Show Polls :: Message Navigator

Conditional Labels for Value (Y) series [message #635100]

Mon, 25 October 2010 11:57

Garey Smiley
Messages: 4
Registered: July 2009

Junior Member

I'm trying to figure out how to have conditional labels for "Value (Y) series" in a Percent Stacked bar chart. I have lots of values in the bar and only want to label those items that are more than X percent.

Report message to a moderator

Re: Conditional Labels for Value (Y) series [message #635123 is a reply to message #635100]

Mon, 25 October 2010 12:55

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Add a beforeDrawDataPoint script like:

function beforeDrawDataPointLabel( dph, label, icsc )
{

if( dph.getPercentileOrthogonalValue() < 0.25 ){
label.setVisible(false);
}else{
label.setVisible(true);
}
}

0.25 is 25% on the label.

Jason

On 10/25/2010 11:57 AM, Garey Smiley wrote:
> I'm trying to figure out how to have conditional labels for "Value (Y)
> series" in a Percent Stacked bar chart. I have lots of values in the bar
> and only want to label those items that are more than X percent.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Conditional Labels for Value (Y) series [message #635143 is a reply to message #635123]

Mon, 25 October 2010 14:21

Garey Smiley
Messages: 4
Registered: July 2009

Junior Member

Thanks! That worked perfectly.

Report message to a moderator

Re: Conditional Labels for Value (Y) series [message #946577 is a reply to message #635100]

Tue, 16 October 2012 06:00

Saurabh Puri
Messages: 10
Registered: February 2012

Junior Member

Hi Jason,

I am trying to display values on the stacked bar chart using "value (Y) series" - show label option.
As some of the stacks are smaller in height which makes the values overlap. Is there any way out??

Please help.
Thanks

[Updated on: Tue, 16 October 2012 06:01]

Report message to a moderator

Re: Conditional Labels for Value (Y) series [message #947390 is a reply to message #946577]

Tue, 16 October 2012 23:40

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

You could always bump the labels to the left or right. You could even alternate the bump.

crcnt=0;
function beforeDrawDataPointLabel( dph, label, icsc )
{
if( crcnt == 0 ){
currl = label.getInsets().getLeft();
label.getInsets().setLeft(currl-8);
}
if( crcnt == 1 ){
currl = label.getInsets().getLeft();
label.getInsets().setLeft(currl+8);
}
crcnt++;
if(crcnt > 1 )crcnt=0;

}

Jason

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Conditional Labels for Value (Y) series [message #955146 is a reply to message #947390]

Tue, 23 October 2012 10:54

Saurabh Puri
Messages: 10
Registered: February 2012

Junior Member

Thanks a lot for the solution.

But i have another problem which was not solved even if i move the label out.
Somehow the values of two or more stacks overlap. Please refer the attached image.

Is there any way out?

Also is there any way where i can put a condition of height

if (height_of_piece_of_stack >= smvalue)
{display label}
else
{not}

Thanks again

Saurabh

Attachment: overlap.jpg
(Size: 33.93KB, Downloaded 56 times)

Report message to a moderator

Re: Conditional Labels for Value (Y) series [message #955665 is a reply to message #955146]

Tue, 23 October 2012 20:19

Michael Williams
Messages: 1362
Registered: July 2009

Senior Member

Did you try using the above code? Or if that inset was not enough, increasing the variance by a few. Like, use 12 instead of 8. In the image, it doesn't appear that you're using this code at all. If you want to hide the label if it's below a certain value, you can do this:

function beforeDrawDataPointLabel( dph, label, icsc )
{
if(dph.getOrthogonalValue() < minValueYouWantToShow){
label.setVisible(false);
}
}

Hope this helps.

Michael Williams
Actuate – The BIRT Company™

BIRT Exchange is now the BIRT Developer Center.

Report message to a moderator

Re: Conditional Labels for Value (Y) series [message #956180 is a reply to message #955665]

Wed, 24 October 2012 05:53

Saurabh Puri
Messages: 10
Registered: February 2012

Junior Member

Hi,

I tried using the code but the problem is not solved even if i increase the variance.
Variance will make the values to shift more towards left but the overlap of labels for one stack still happens. Can i alternate the label bumps of the same stack??

Also, because my data values varies, can one compare some way the relative value (like percentages) to disable/enable label display.

function beforeDrawDataPointLabel( dph, label, icsc )
{
if(value<some_percent){
label.setVisible(false);
}
}

Thanks in Advance
Saurabh

[Updated on: Wed, 24 October 2012 05:59]

Report message to a moderator

Re: Conditional Labels for Value (Y) series [message #958123 is a reply to message #956180]

Thu, 25 October 2012 15:32

Michael Williams
Messages: 1362
Registered: July 2009

Senior Member

The inset code is made to alternate which direction the label goes. The crcnt should alternate between 0 and 1, as you encounter each label. This is why one of the statements is currl - 8 and one is currl + 8.

As for the hiding a section of a bar based on its percentage of the stacked bar, you'd probably be dealing with a little bit more complicated script. The percentage value you can get from dph would be the percentage of a bar section across the optional grouping, which is spread across the different bars. It doesn't tell you the percentage of the current section of the stack it's in. That may just be my chart sample I'm working with though. The way I see it, you'd have to use the afterDataSetFilled script to figure out the total for each bar, then in the dataPointLabel script, you'd figure the percentage based on the bar's value. I could be wrong though. Hope this helps. Smile

Michael Williams
Actuate – The BIRT Company™

BIRT Exchange is now the BIRT Developer Center.

Report message to a moderator

Previous Topic:	PHP Javabridge with BIRT 4
Next Topic:	BIRT- date manipulation for query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 09 05:49:20 EST 2013