Average calculated in Crosstab

0
Hi Guys (and girls) 
 
Im struggling with the following problem in iReport:
 
I have a crosstab with uptimes for  2 systems. (the top 2 rows) over the past month.
Now 1 system went down somewhere during the month (decreasing uptime percentage) and our supplier made arrangements to have the problem fixed. This would take some days to fix so we agree to _not count_ the system availability (does this make sense?)
 
Anyway.
 
After evaluating the availability KPI I run into a disagreement with my supplier. Jasperreport says the Availability is 98.61% but Excel thinks it's 98.72%
This is caused by Jaspersoft calculating the Average based on ALL the cells in the first 2 rows where Excel calculates it based on the AVERAGES per day.
Is there any way to change the calculation inside Jasperreport from cell to average per day?
 

Cheers,

Sjoerd

 

100

100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100
100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100

95.8

75 75 75           96,95
100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 97.9 87.5 87.5 87.5 100 100 100 100 100 98,61

 

sjoerd.jump's picture
Joined: Oct 29 2012 - 2:39pm
Last seen: 4 years 7 months ago

1 Answer:

1

Right now I use a workaround

have added a variable to my report that calculates an average availablity over the 2 systems.
In the crosstab i have added a new measure with my new variable as expression, set to average again.

This is now an "average average" just what i was looking for.

sjoerd.jump's picture
Joined: Oct 29 2012 - 2:39pm
Last seen: 4 years 7 months ago
Feedback