How to create calculate filed rank?

Hi Guy,

i have duplicate row app id but i need to use total only first row (rank 1).

i would like to

  1. create add calculation filed with rank function
    2 filter by rank = 1

image

Thanks for help

Hi @Siriphon

Is there any additional field like created date and you want to filter & keep only the latest records ?

If its duplicate records having all the columns having the same value , its better to the Distinct in the underlying datasource through a view or writing a custom sql in QuickSight with Distinct.

Please find a similar request in this community post .

Thanks
VInod

i can’t write sql because of permission level,So i have to write formula on QS only
Could you please advice?

Did you try rank function?

1 Like

This is a result when i use rank formula

rank([{af_app_form} ASC])

it should be column c_rank 1 to 9 because count_dup_appform = 9

Thanks for advice.

Hello @Siriphon , @ErikG , and @apjvinod !

@Siriphon did @ErikG or @Siriphon 's suggestion help you resolve this, and if so could you mark their comment as the solution to help the community? If not, are you still working on this issue or were you able to resolve this?

Hello @Siriphon , @ErikG , and @apjvinod !

It has been some time since there has been activity on this thread but we would still like to help find a solution. If there is not activity in the next 3 business days this topic will be archived.