This content has been marked as final. Show 2 replies
You could do a distinct in your query, that gives only one value of its kind.
Would that help?
I know this is a really old question but ...
I thought I'd provide a little insight since I had the same problem. If, as in the case described, the values are specified to have 0 decimal places, and the range of the data is, say, between 0 and a small number then the Y scale/range may be 0.0, 0.5, 1.0, 1.5, 2.0, ... But at 1 decimal place, these may display (truncated?/rounded) as 0, 0, 1, 1, 2, ... The easy solution would be to specify 1 (or more) decimal places. However, the easy solution has other effects. My stacked bar chart was very dense with only enough room to show a single digit for the Values. This became unreadable when the value 1 (one) was replaced by 1.2 and 2 by 2.3. So I unchecked display Values. (Why couldn't the values display staggered like labels do so they they don't overlap?)
So even though, I had intended to display "values," I had to give that up when I showed additional decimals in the labels.