BIRT Expression evaluation

Hi,

I'm trying to create a line chart. My charts category is a timestamp, grouped on minutes. My series should be the count of results where row["Status"] == "Violated". My problem is that I don't know how to cast the boolean value of the series expression to an integer(0 for false, 1 for true), so that I can sum over it.

Greetings

Fabian

Find more posts tagged with

Comments

matrium

Doesn't anybody have had the same problem?

cypherdj

Fabian,

you don't need this at all, why don't you use a count as shown in the following screenshot?

Hope that helps,
Cedric

matrium

Hi,

thanks for the answer, but my problem is that I have two series:
1. A simple series that uses count to get the number of items in the group
2. A series that counts the number of items in the group where row["Status"] == violated

So count works for the first series, but not for the second.