Eclipse Community Forums: BIRT » BIRT exclude null labels from chart and legend

Help

Home

Home » Archived » BIRT » BIRT exclude null labels from chart and legend

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

BIRT exclude null labels from chart and legend [message #1337178]

Tue, 06 May 2014 19:08

Syed Shah

Messages: 13
Registered: April 2014

Junior Member

Hi

I am working on a dashboard and am stuck in one graph. Basically I am making a plot on below scenario

I have four towns that I am doing crime analysis in them. The four towns are A, B, C, D and My Town. On x axis, We have crime types like Burglary, Robbery, Murder etc..on y axis We are counting the number of crimes and we have put Towns in Y axis grouping (Legends)

Now here is the problem that I am facing. I want to plot my town on first series as a bar chart, and plot the rest of towns as a line graph in second series. For the first series (which is bar and only represented by my town), I wanted to only plot my town so I put the below expression in the y value series

if(row["Towns"] == 'My Town')
(
row["Crime Count"]
)

I wanted to see if my town is being plotted correctly so I check the graph. What I noticed was that I am also seeing the other towns in the legend and on the chart, they are not plotted but the gap between my town bar is so much that I realized that the graph is still taking the null towns into consideration

![enter image description here][1]

My question is that how can I make the above expression so that the legend only shows my town and the graph only plots my town for the first series. I want to hide the null labels/entries from legend and from graph

Thank You
Syed

Report message to a moderator