dynamically add new column when having identical values in column and conditioned on date

Hi all

I have this dataset where i would like to dynamically add a column that specifies the number of repeated values in a specific column depending on the timestamp.

For instance if we have a timestamp user name and ID, if two ID's are identical the we should add a new column saying execution 1 for the one that has the earliest timestmap and 2 for the second earliest etc.

Do anyone know if that is possible?

Example

input

Output

Accepted answers

vizAlter

Hi @Kk_larsen — Hope the attached solution will be helpful, if not let me know.

If this post assists in resolving the question, please mark it "Like", or "Solved" with a Like if it resolves the question. This will help other users find the same answer/resolution. Thank you.

Fill down (using Tile).yxmd

All comments

ImadZidan

Hello @Kk_larsen ,

This is an idea.

ExecutionIncrement.yxmd

vizAlter

Hi @Kk_larsen — Hope the attached solution will be helpful, if not let me know.

If this post assists in resolving the question, please mark it "Like", or "Solved" with a Like if it resolves the question. This will help other users find the same answer/resolution. Thank you.

Fill down (using Tile).yxmd

Kk_larsen

Thank you worked perfectly!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703