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_idvisitor_idsession_idTime stampPage Name
sk484462552301220202010/22/19 10:29 AMHello1
sk484462552301220202010/22/19 10:30 AMProjects Page
sk484462552301220202010/22/19 10:32 AMClick on A Project - Project1
sk484462552301220202010/22/19 10:34 AMClick on "Connect an API (bottom right on Project)
sk484462552301220202010/22/19 10:36 AMAPI catalog page
sk484462552301220202010/22/19 10:38 AMSelect an API - API details page
sk484462552301220202010/22/19 10:40 AMConnect to Project button
sk484462552301220202010/22/19 10:42 AMSelect API environment
sk484462552301220202010/22/19 10:44 AMHit Connect
sk484462552301220202010/22/19 10:46 AMProjects Page
sk484462552301220202010/22/19 10:48 AMClick on A Project - Project1
sk484462552301220202010/22/19 10:50 AMClick on "Connect an API (bottom right on Project)
sk484462552301220202010/22/19 10:52 AMAPI catalog page
sk484462552301220202010/22/19 10:54 AMSelect an API - API details page
sk484462552301220202010/22/19 10:56 AMConnect to Project button
sk484462552301220202010/22/19 10:58 AMSelect API environment
sk484462552301220202010/22/19 10:58 AMHello2
sk484462552301220202010/22/19 11:00 AMProjects Page
sk484462552301220202010/22/19 11:02 AMClick on A Project - Project1
sk484462552301220202010/22/19 11:04 AMClick on "Connect an API (bottom right on Project)
sk484462552301220202010/22/19 11:06 AMAPI catalog page
sk484462552301220202110/22/19 11:08 AMSelect an API - API details page
sk484462552301220202110/22/19 11:10 AMConnect to Project button
GK32145643214512342110/22/19 10:30 AMHep123
GK32145643214512342110/22/19 10:30 AMHep12312fdrg
GK32145643214512342110/22/19 10:31 AMProjects Page
GK32145643214512342110/22/19 10:33 AMClick on A Project - Project1
GK32145643214512342110/22/19 10:35 AMClick on "Connect an API (bottom right on Project)
GK32145643214512342110/22/19 10:37 AMAPI catalog page
GK32145643214512342110/22/19 10:39 AMSelect an API - API details page
GK32145643214512342110/22/19 10:41 AMConnect to Project button
GK32145643214512342110/22/19 10:43 AMSelect API environment
GK32145643214512342110/22/19 10:45 AMHit Connect
GK32145643214512342110/22/19 10:47 AMProjects Page
GK32145643214512342110/22/19 10:49 AMClick on A Project - Project1
GK32145643214512342110/22/19 10:51 AMClick on "Connect an API (bottom right on Project)
GK32145643214512342110/22/19 10:53 AMAPI catalog page
GK32145643214512342110/22/19 10:55 AMSelect an API - API details page
GK32145643214512342110/22/19 10:57 AMConnect to Project button
GK32145643214512342110/22/19 10:59 AMSelect API environment

 

Please see above table,

Need help in adding index column based on "Page Name" Column.

Index Number should start from row Value "Project Info"(This row index should be 1) and end at "Hit Connect"(This row index value should be 8, Filter should be based on Mudid & Time Stamp, as there is chance multi user can use website same time)

-Some times "Hit connect" wont be the last step, instead previous step(s). New solution should be intellegent enough to handle indexing this way.

Really appreciate if anyone can help. Thanks in advance.

Regards,

Siva

Need Help

2 Replies

  • 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