# How to get a series aggregation in Lens?
**URL:** https://discuss.elastic.co/t/how-to-get-a-series-aggregation-in-lens/326438
**Category:** Kibana
**Tags:** lens
**Created:** [February 24, 2023, 1:00pm UTC](https://discuss.elastic.co/t/how-to-get-a-series-aggregation-in-lens/326438 "2023-02-24T13:00:31Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Rick\_V](https://discuss.elastic.co/u/Rick_V)
#### Post date: [February 24, 2023, 1:00pm UTC](https://discuss.elastic.co/t/how-to-get-a-series-aggregation-in-lens/326438/1 "2023-02-24T13:00:31Z")
Hi,
Currently i am using a TSVB visualization with a series aggregation like described in [this post](https://discuss.elastic.co/t/how-to-get-the-total-of-memory-and-cpu-usage-of-my-cluster/288170)
to visualize apm data, it shows the duration of a series of transactions. The aggregation first takes the average of the duration of transactions with the same name, and then sums three transactions to get the average duration of the distributed trace. But now i would like to categorize the outcomes into three groups: good fair and bad based on the duration, and show that in a table for example. How could i do that? I was thinking of using Lens \> table, but that doesn't support series aggregation...
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 24, 2023, 1:00pm UTC](https://discuss.elastic.co/t/how-to-get-a-series-aggregation-in-lens/326438/2 "2023-03-24T13:00:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.