I have a DB view over a layer with columns:
objectId, Sector (char), Value (integer), shape
The values are integer 0 - 80.
In the map - the values are shown correctly.
In Box plot - the chart recognize the range of the values correctly.
But, in all other charts, especially column and bar chart - the Y axis values are between -0.5 - +0.5 and the histogram is empty.
The original data type of the value column was decimal(4,1) with nulls, and we've simplified them to integer without nulls, and the problem still exists.
In other columns from the same view, with similar data types and values - there is no problem.
We couldn't find the diference, the reason and the solution.
Did any one encounter this kind problem?
Any help will be appreciated.