topic Re: How to Select an Offset? in App Development

How to Select an Offset?

Trever — Wed, 17 Nov 2021 22:06:50 GMT

I've got a table with several dozen associate names and performance numbers. The entire list isn't visible at once, so I'd like to create three side-by-side tables. Table 1 would show associates 1-10, Table 2 would show 11-20, and Table 3 showing the remainder.

I've tried to use the TOP() function in Limitation, but that doesn't seem to work.

This isn't a static list, so I can't specify A-F, or by employee id, etc. Need to do something similar to the SQL LIMIT and OFFSET functionality.

Creative ideas on how to accomplish this?

Re: How to Select an Offset?

stevejoyce — Wed, 17 Nov 2021 23:37:07 GMT

I would use rank().

if you don't need totals for all associates (if that's what your splitting by), you can do a calculated dimension. otherwise use it in your table's expressions.

sum({< field = {"=rank(rank(field)) <=10"} >} measure)

sum({< field = {"=rank(rank(field)) <=20 and rank(rank(field)) > 10"} >} measure)

Re: How to Select an Offset?

Trever — Fri, 19 Nov 2021 20:18:27 GMT

Thanks - I learned something new!