Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Indexing based on a row value

Hello All, I need some help in creating index column for below scenario.   mud_id visitor_id session_id Time stamp Page Name sk4844625 523012 202020 10/22/19 10:29 AM Hello1 sk4844...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

At first thought, you can create an index like

index = countx(filter(table, table[mud_id]=earlier(mud_id) && table[timestamp]<=earlier(table[timestamp])),table[timestamp])

 

If you can provide a number to the steps then and index can reset based on that

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the reply. 

I tried suggested solution, but indexing happens based on Mudid,mean starts from 1 for the mudid.

 

I need  something like below (Index based on Page Name)

mud_idvisitor_idsession_idTime stampPage NameIndex
sk484462552301220202010/22/19 10:29 AMHello1 
sk484462552301220202010/22/19 10:30 AMProjects Page1
sk484462552301220202010/22/19 10:32 AMClick on A Project - Project12
sk484462552301220202010/22/19 10:34 AMClick on "Connect an API (bottom right on Project)3
sk484462552301220202010/22/19 10:36 AMAPI catalog page4
sk484462552301220202010/22/19 10:38 AMSelect an API - API details page5
sk484462552301220202010/22/19 10:40 AMConnect to Project button6
sk484462552301220202010/22/19 10:42 AMSelect API environment7
sk484462552301220202010/22/19 10:44 AMHit Connect8
sk484462552301220202010/22/19 10:46 AMProjects Page1
sk484462552301220202010/22/19 10:48 AMClick on A Project - Project12
sk484462552301220202010/22/19 10:50 AMClick on "Connect an API (bottom right on Project)3
sk484462552301220202010/22/19 10:52 AMAPI catalog page4
sk484462552301220202010/22/19 10:54 AMSelect an API - API details page5
sk484462552301220202010/22/19 10:56 AMConnect to Project button6
sk484462552301220202010/22/19 10:58 AMSelect API environment7
sk484462552301220202010/22/19 10:58 AMHello2 
sk484462552301220202010/22/19 11:00 AMProjects Page1
sk484462552301220202010/22/19 11:02 AMClick on A Project - Project12
sk484462552301220202010/22/19 11:04 AMClick on "Connect an API (bottom right on Project)3
sk484462552301220202010/22/19 11:06 AMAPI catalog page4
sk484462552301220202110/22/19 11:08 AMSelect an API - API details page5
sk484462552301220202110/22/19 11:10 AMConnect to Project button6
GK32145643214512342110/22/19 10:30 AMHep123 
GK32145643214512342110/22/19 10:30 AMHep12312fdrg 
GK32145643214512342110/22/19 10:31 AMProjects Page1
GK32145643214512342110/22/19 10:33 AMClick on A Project - Project12
GK32145643214512342110/22/19 10:35 AMClick on "Connect an API (bottom right on Project)3
GK32145643214512342110/22/19 10:37 AMAPI catalog page4
GK32145643214512342110/22/19 10:39 AMSelect an API - API details page5
GK32145643214512342110/22/19 10:41 AMConnect to Project button6
GK32145643214512342110/22/19 10:43 AMSelect API environment7
GK32145643214512342110/22/19 10:45 AMHit Connect8

Thanks,

SIva