# Group fields in a visualization for time series **URL:** \ **Category:** Kibana\ **Tags:** vega, lens, timelion\ **Created:** [February 20, 2023, 7:23am UTC](https://discuss.elastic.co/t/group-fields-in-a-visualization-for-time-series/325934 "2023-02-20T07:23:10Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![dannie-ml](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dannie-ml/32/99559_2.png) [@dannie-ml](https://discuss.elastic.co/u/dannie-ml)\ **Post date:** [February 20, 2023, 7:23am UTC](https://discuss.elastic.co/t/group-fields-in-a-visualization-for-time-series/325934/1 "2023-02-20T07:23:10Z")
Hi, im new in Elastic and i want to build some visualization of this table: ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/6/a60f9374aa4765f42eaadbb809420c28aa63ef74.png) But when building both lens or line chart or vega-lite (in this one i really dont know how to achieve a visualization) but for the other ones i have the problem that for composite name as you can see i have repeated names but different values and when trying to make the viz, i have only 4 data point through time. So what i need to achieve is in somehow group composite\_names and composite\_revision in x and in y the values of num\_instances. For now the only way i can see the right behavior is if a choose by "\_id" in term aggregation for "Line" visualization I hope you can understand the problem that i want to resolve. Thank you ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 20, 2023, 7:23am UTC](https://discuss.elastic.co/t/group-fields-in-a-visualization-for-time-series/325934/2 "2023-03-20T07:23:36Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed. ---
**Author:** ![drewdaemon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/drewdaemon/32/97779_2.png) [@drewdaemon](https://discuss.elastic.co/u/drewdaemon)\ **Post date:** [August 2, 2023, 8:36pm UTC](https://discuss.elastic.co/t/group-fields-in-a-visualization-for-time-series/325934/3 "2023-08-02T20:36:33Z")
Hi. As I understand it, you're trying to do the equivalent of a GROUP BY in SQL with `name` and `revision` being your GROUP BY fields. **EDIT:** Use @Marco_Liberati 's solution below ---
**Author:** ![drewdaemon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/drewdaemon/32/97779_2.png) [@drewdaemon](https://discuss.elastic.co/u/drewdaemon)\ **Post date:** [August 2, 2023, 8:37pm UTC](https://discuss.elastic.co/t/group-fields-in-a-visualization-for-time-series/325934/4 "2023-08-02T20:37:08Z")
---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [August 3, 2023, 7:20am UTC](https://discuss.elastic.co/t/group-fields-in-a-visualization-for-time-series/325934/5 "2023-08-03T07:20:16Z")
Have you tried already multi-terms in Lens? That sounds a possible solution to me. ![Screenshot 2023-08-03 at 09.19.54](https://us1.discourse-cdn.com/elastic/original/3X/4/7/47168e14461278acc8fb7b84032069368ee2ad64.png)