Forum Discussion

Divous's avatar
Divous
Icon for Helper III rankHelper III
4 years ago

RANKX with multiple FILTER

Hi community,   I would like to add the order of support and users (see desired output). I manage to number the order according to the id and time columns with RANKX, but I no longer know how to ad...
Need Help
Tutorial Requests
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
4 years ago

Your question has nothing to do with RANKX at all. Only a tricky calculation based off on different delimiters.

 

Divous's avatar
Divous
Icon for Helper III rankHelper III
4 years ago

Hi CNENFRNL 

thanks for response!

Ok, I was completly wrong.. 😕 still much to learn 🙂

 

When I try to use your solution I found two errors:
1) # of rank should be same until one of them respond.


2) on my date it doesnt rank support correctly (maybe because there is robot again after user?)


+ if I can ask you for some improvement? Its possible to rank it after specific message in message_text column? See picture (blue desired) maybe it will be better to understand

 

Thanks in advance!

 

Best,

Divous