niels.cadee Posted November 26, 2012 Share Posted November 26, 2012 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! Link to comment Share on other sites More sharing options...
niels.cadee Posted May 13, 2013 Author Share Posted May 13, 2013 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now