Counting Occurences and Crating Buckets


#1

Hi Sam, I have a couple of Measures that measure the performance of different forecasting Models to the Actual.
I have been asked to create the following analysis;

Count how many times certain comparisons to Actual fall in the following Buckets;

< than 3%
3-5 %
and > 5 %

If you can point me in the right direction in terms of method, that would be awesome. It seems simple in terms of Row Data but I am struggling with basing it on the Measure.


#2

Have you gone through the segmentation and grouping techniques yet? These concepts should certainly solve a scenario like this.

Here are some links.

While these aren’t exactly the same, it’s all the same techniques and ideas for grouping dynamically.

See how you go with these and come back if any problems.