Session Counter over time Visualisation

[gruselglatz]

Hi,

I have the following Data:
Timestamp, SessionState (Opened), SessionID
Timestamp, SessionState (Closed), SessionID

And I need to visualize the amount of open sessions at "timeframe". Is this somehow possible with Kibana? Maybe some Tvsb curve? Vega is a little bit too much for my sry.

Thanks

[mattkime (Matthew Kime)]

Hello @gruselglatz

How is your data being indexed? Perhaps we could get the data into Elasticsearch like -

SessionID, TimestampOpened, TimestampClosed

which would make the query simple.

[gruselglatz]

Hey @mattkime thanks for the fast answer.

Unfortunately i only get the messages like this:

2020-08-26 07:41:23.609 [4] 00000000 Client (host=stw4ts1, sessionId=4e2): Open WebSocket connection
2020-08-26 07:41:26.813 [4] 00000000 Client (host=stw4ts1, sessionId=4e2, applicationId=WebApp): Close WebSocket connection

Is this then even possible? With some math or scripting?

Thanks

[mattkime (Matthew Kime)]

You either need to change how you ingest the data or post process the documents.

Here's a discussion around a similar need - Calculation time difference between two document

[gruselglatz]

Thanks, I finally convinced them to give the APM-Agent a try, and i collect the Stats now via JMX.