Repeated values on average axis scale

[niels.cadee]

Hi,

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]

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.