Repeated values on average axis scale



I'm using JasperServer Pro version 4.5.0 and have a problem creating Ad Hoc reports. Every time I create a graph of a field (e.g. civil status, single/married/partnership) against a measure (e.g. number of days in hospital), I get a strange display of values on the Y axis. With Sum, Min, Max, Count it works fine, but with Average I get repeated vales: 0 0 0 1 1 1 2 2 2 3 along the ticks on the axis. 

Any ideas why this happens and what can be done about it?

Many thanks in advance for your help and suggestions!

niels.cadee's picture
Joined: Nov 9 2012 - 5:53am
Last seen: 7 years 5 months ago
Hi, I finally got the solution from JasperSoft Support. Part of the problem was that my meauseres are integers, and the average includes decimals. There are two ways to solve the problem: 1. In the Ad Hoc chart interface, right-click on the measure name above the chart and select Change Data format. Then choose a format that displays decimals: -1234.56. 2. In the domain designer, on the Display tab, edit the measure properties. For Summary Format, choose Average. This also fixes the axis problem.
niels.cadee - 7 years 5 months ago

0 Answers:

No answers yet