topic Re: rank bands questions in App Development

rank bands questions

alexpanjhc — Fri, 30 May 2025 02:15:59 GMT

I am creating a few Ranks bands and i created a few dimensions for this purpose. to make it simple, it looks like this

load

ID, ranks

resident table;

if (rank<=10, 'Top 10',

if (rank<=20, 'Top 20',

if (rank<=50, 'Top 50',

....))) as RankBand

so i created a selection box for RankBand. however, Top 20 is 11-20, top 50 is 21-50

is there a way for this dimension, when selecting top 20 it will show from 1-20 and so on?

thanks!

rwunderlich — Fri, 30 May 2025 05:29:00 GMT

A flexible way to do this is to generate a Range table that can map rank values to many RankBands like this:

// Generate some test data
Ranks:
LOAD RecNo() as rank
AutoGenerate 75;

Ranges:
LOAD * INLINE [
RankBand, RangeStart, RangeEnd
Top 10, 1, 10
Top 20, 1, 20
Top 50, 1, 50
];

Join (Ranges)
IntervalMatch (rank) LOAD RangeStart, RangeEnd RESIDENT Ranges;
DROP FIELDS RangeStart, RangeEnd;