About wkk

wkk · ‎11-10-2023

I slightly changed the query, as I didn't want to use search. Query ends up with the same results. index=your_index | stats values(SUBMITTED_FROM) AS SUBMITTED_FROM values(STAGE) AS STAGE BY SESSION_ID | where SUBMITTED_FROM=startPage STAGE=submit | stats count BY SESSION_ID

wkk · ‎11-10-2023

@gcusello thank you that solved my case

wkk · ‎11-10-2023

Hi! 🙂 I have a fallowing table: SESSION_ID SUBMITTED_FROM STAGE 1 submit 1 startPage someStage1 2 submit 2 page1 someStage1 2 page2 someStage2 How could I count the number of SESSION_IDs that has SUBMITTED_FROM=startPage and STAGE=submit? So looking at the above table the outcome of that logic should be 2 SESSION_IDs

Posts	3
Solutions	0
Karma Given	1
Karma Received	0
Member Since	‎11-10-2023

Online Status	Offline
Date Last Visited	‎11-10-2023 08:59 AM

Extract and count IDs from a table

Re: Extract and count IDs from a table

Re: Extract and count IDs from a table

Extract and count IDs from a table