Help with grid charts/expression grouping expressions
So, I have a grid chart, and I want the Y Axis to be a measure value: Sum(Actual Quantity Ordered). From what I can tell, the fact that I have so many possible measure values on my Y Axis is causing my grid chart to spit out tiny circles as data points.
So I have two questions: is there some setting I can use to make my Y Axis value reflect ranges, instead of exact values?
If not, I'm assuming I'll need to group my measure values somehow. I'm attempting an IF statement in the expression definition:
Re: Help with grid charts/expression grouping expressions
Thanks. However, I forgot to mention that this shouldn't actually be applied to an expression. It's going to be a dimension. That is, I need four buckets of values on my Y axis dimension. And sorry, what you gave me doesn't work for that, and I have personal edition, so I can't look at your copy. Would the "bucketing" take place more smoothly at the script level?