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 |
1 Answer:
Posted on September 24, 2013 at 2:58am
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.
