Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar chart showing the average employee rating by region. The employee rating is a number anywhere between 1 and 3, but the problem is 1 is considered the highest rating, and 3 the lowest. See the example below- what I'd like is for the axis to go from 3 at the x/y to 1, instead of 0 to 3. The easy answer would be to multiply by -1 and show the negative value. My problem is that the negative values always extend from the top of the chart down, I can't figure out a way to invert it.. I've attached an example qvw, thanks in advance for any help with this!
See if you like this one:
Inverse expression, as you tried:
- avg(Rating)
Create Bar Offset expression (attribute expression)
avg(Rating)-3
Regards,
Michael
Does anyone have any suggestion / solution ?
Please find attachment.
Similar approach as Michael suggested, with some minor mods.
Are you sure that you have understood the Problem?