How to Order a table

[marco_puccetti]

Hello i need a table with the top 10 Images loaded into an istagram account but my question is how to order the datas and to limit the results to the first 10 images?

Thanks

Marco

[simospa]

Hi Marco 🙂

which fields have you for this order by issue?

Consider to use a chart (straight table) and not a Table object: you have a Limit Dimension tab that could help you.

S.

[#3]

Hi Marco,

Use the below statements:

Dimension: = if(aggr(rank(sum(Value)),Dim)<=10,Dim)

Expression: sum(Value)

Regards,

Sridhar

[marco_puccetti]

Thanks

Marco

[marco_puccetti]

As regard the date what have i to set in this section?

Thanks

Marco

[buzzy996]

u can use dimension limits tab and define value as top 10 and uncheck other check boc from same tab.

[marco_puccetti · Accepted solution]

To set the top 10 ordering is it correct?

[buzzy996]

yes dear,are u got expected out after that setting?

[marco_puccetti]

With this setting combined with the date sorting i get a tables sorted by date from the most recent to the less recent.

Marco

[buzzy996]

yes,tht will give result accordingly ur dimensions & expresions,tht's not ur looking for?