Display Rank without custom query

Currently we are showing rank using custom query. There is no way to use rank from Arcadia function, isn’t it.
Since there are some global filters that applying to all dashboards so we need to consider to include in individual query.
Thank you very much.

@Stima_Livingpresent it depends on what exactly you are trying to do, and if you are using Arcadia Enterprise which contains our own back-end processing engine.

When using Enterprise, we provide various window/analytic functions such as “rank” which provides similar functionality.

Example below shows creating a rank based on sum of sales using the following expression:

 rank() over (order by sum([sales]) desc)

1 Like

Thank you very much.
Just found that from Derived VDO as well. First when try, I could not find from function in expression so thought it was not available.

1 Like