topic Re: order a table with expression in App Development

order a table with expression

igorgois_ — Fri, 06 Nov 2020 18:05:36 GMT

I would like to order a table with a dimension that have duplicated values (see print)

I tried min, max, sum, aggr() but without success

I also tried with dual, but the descriptions became aligned to the right as a number. I need them on the left

Load script example:

load * inline [
kpi_id,kpi_desc,value,order_visual
1,desc1,10,1
2,desc2,20,2
3,desc3,30,3
4,desc2,40,5
5,desc5,50,4
];

Any ideas?

Thanks in advance

eberhardteduard — Fri, 06 Nov 2020 18:26:39 GMT

Hi Igor, see attached print:

p.s: the right table has the answer for your question.

igorgois_ — Fri, 06 Nov 2020 18:44:11 GMT

Nice job, Eduardo!

But with this solution I can't format the "text" as a number with thousands and decimals 😕

Thank you very much anyway