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
|
|
|
|
Powered by
FUDForum. Page generated in 0.02996 seconds