Session Count per number of Transactions

[Max_Handle (Max)]

Hi,

I am trying to solve the following problem with little success so far concerning Barcharts:

• X-axis --> Number of rows per Session
• Y-axis --> Count of Sessions

So it would look something like this:

There are 4 Sessions that have only one transaction (or one row in discover), 3 Sessions have 2 transaction etc.

Is there some way to achieve this? It does not necessarily need to be a bar chart. Any help would be very much appreciated!

[wylie (Wylie Conlon)]

You need to pre-aggregate your data into a form that you can analyze. Most users who do session-based analysis use the Elasticsearch transformations feature: https://www.elastic.co/guide/en/elasticsearch/reference/current/transforms.html