# Time series data grouping

**URL:** https://discuss.elastic.co/t/time-series-data-grouping/130320
**Category:** Kibana
**Created:** [May 2, 2018, 8:23pm UTC](https://discuss.elastic.co/t/time-series-data-grouping/130320 "2018-05-02T20:23:16Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Maddy\_M](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/maddy_m/32/45638_2.png) [@Maddy\_M](https://discuss.elastic.co/u/Maddy_M)
#### Post date: [May 2, 2018, 8:23pm UTC](https://discuss.elastic.co/t/time-series-data-grouping/130320/1 "2018-05-02T20:23:16Z")

</div>

Hi,

I have values like below and I would like to create a timeseries/line chart with groupby ID field.

Id=1234 A=1, B=3, C=6, D=9  
Id=2345 A=2, B=1, C=7, D=5  
Id=2345 A=4, B=6, C=5, D=0

X-axis is timestamp  
Y -axis, values(lines) for A,B,C,D groupby ID.

I am able to create lines chart with all values but unable to group the values by ID.

Could you please advise?

Thanks,  
Venkat

---

<div class="post-metadata">

### Author: ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)
#### Post date: [May 2, 2018, 8:41pm UTC](https://discuss.elastic.co/t/time-series-data-grouping/130320/2 "2018-05-02T20:41:46Z")

</div>

Hey @Maddy_M, you can create a terms aggregation on the “id” column and it’ll do the equivalent of a group by.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 30, 2018, 8:41pm UTC](https://discuss.elastic.co/t/time-series-data-grouping/130320/3 "2018-05-30T20:41:51Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.