# Session Count per number of Transactions
**URL:** https://discuss.elastic.co/t/session-count-per-number-of-transactions/255959
**Category:** Kibana
**Created:** [November 19, 2020, 9:59am UTC](https://discuss.elastic.co/t/session-count-per-number-of-transactions/255959 "2020-11-19T09:59:35Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Max\_Handle](https://discuss.elastic.co/u/Max_Handle)
#### Post date: [November 19, 2020, 9:59am UTC](https://discuss.elastic.co/t/session-count-per-number-of-transactions/255959/1 "2020-11-19T09:59:35Z")
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!
---
### Author:  [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [November 19, 2020, 4:14pm UTC](https://discuss.elastic.co/t/session-count-per-number-of-transactions/255959/2 "2020-11-19T16:14:14Z")
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](https://www.elastic.co/guide/en/elasticsearch/reference/current/transforms.html)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 17, 2020, 4:14pm UTC](https://discuss.elastic.co/t/session-count-per-number-of-transactions/255959/3 "2020-12-17T16:14:25Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.