DMR - Grouping on a Tuple Calculated item.

[Robl]

The user prompt slicers are resolved – these are departments, products, dates etc.
After applying the slicers for each "Item" two measures are divided to get a percentage.
This percentage is then converted to a 'score' by a formula; the score being 1,2,3 (or A,B,C)
We then need to group the "items" by the "score".
Not just that, we need to count the number of "items" within each "score" group and apply this to a Conditional stacked bar chart.

The difficulty I have is that the "score" is a tuple based object and you can't group on a tuple.

All attempts I've tried so far have not allowed a grouping, have not working with slicers, have meant individual sets for "score" that can't be used with conditional palettes.
Does anyone have any suggestions?
Either a full solution, or just a point in a direction I haven't tried yet.
Thanks.

[CognosPaul]

I'm a little confused on your final goal, can you post a mockup?

If I understand, you have a dataset that the user can filter in certain ways. Once complete, you want to bucket the rows into 3 scores, and present the count in some way?

So you'd have a column graph that shows the number of rows that meet score 1, score 2, and score 3?

Take a look at the attached, if I understood correctly it does what you're asking for.

[Robl]

That's great.
Thanks.

I managed to find a solution that looked very similar.

I kept getting errors about mismatched Hierarchies, so I ended up breaking the member calculations out an assigning them to a blank hierarchy so they could then be built into a set.
I think it was complicated further by the Score formula being based on an attribute of the dim the sets were based on which I didn't mention at the start.