crosstab - wrong measure definition?

[dman]

Hi all,

 

I use three groups based on the fields created from the sql query: “IPGroup”, “CategoryGroup”, and “SeverityGroup”.

Further I defined a variable “count_severity_filtered” (Class: Integer, Calculation: Sum, ResetType: Group, Reset group: SeverityGroup, Variable Expr.: “new Integer(($P{REPORT_SCRIPTLET}.matchesTimeFilter($P{timefilter}, $F{TIME})) ? 1 : 0”, Initial Value Expression: “new Integer(0)”). This variable is different from the automatically generated variable “SeverityGroup_COUNT”. I defined it because I have to filter the occurrence of severities depending on a specified timefilter. The scriptlet method works perfect, I checked both variables in separate textfields.

 

In the summary band I use the variable “count_severity_filtered” as a measure for my crosstab.

The crosstab is defined as follows:

- Row groups: ip ($F{IP}), category ($F{CATEGORY})

- Column groups: severity ($F{SEVERITY})

- Measures:  count_severityMeasure (Class: Integer, Value Expr.: “$V{count_severity_filtered}”, Calculation: Count)

 

The problem is: it seems that the crosstab measure calculation isn’t based on my variable “count_severity_filtered” but rather on “SeverityGroup_COUNT”.  

Any ideas why this happens?

 

Thanks in advance for any hints,

DM

 

 

[Giulio Toffoli]

You shold use the calculation SUM for your variable, not COUNT.

Giulio