Computed column to assign Rank

[PunamNaik]

I have a column for total no. of transactions done by customers. I need to add a column for Rank and assign rank(1,2,3,...) to these customers based on no. of transactions. How can I achieve this.

[fbaligand]

First, I guess that you have one row by customer, using a "Terms" bucket. So you can sort your customers bucket by "no. of transactions" metric (descending order). Then you check "Add a row number column" option. It will add head column "#" that is actually the rank.

[PunamNaik]

@fbaligand Thanks for replying. Yes I have a customer Id column, I missed to mention it previously, but here's how my table look like.

So in here if you see customer A & B both should have rank 1, as they have equal Txn count across stores. Therefore "Add row number column" option will not be useful. Pls share your input on this. Thank you again.

[fbaligand]

Well, to my known, you can sort lines customer id by descending Total Txn. But I have no solution to generate a Rank column as you wish.

it is possible using « # » column trick. But it works only if you have one row per customer id. That is not your case.