# How can the measured values of time series in one visualization be connected via a line per each time series?
**URL:** https://discuss.elastic.co/t/how-can-the-measured-values-of-time-series-in-one-visualization-be-connected-via-a-line-per-each-time-series/189125
**Category:** Kibana
**Created:** [July 5, 2019, 2:31pm UTC](https://discuss.elastic.co/t/how-can-the-measured-values-of-time-series-in-one-visualization-be-connected-via-a-line-per-each-time-series/189125 "2019-07-05T14:31:58Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@bkruenelke](https://discuss.elastic.co/u/bkruenelke)
#### Post date: [July 5, 2019, 2:31pm UTC](https://discuss.elastic.co/t/how-can-the-measured-values-of-time-series-in-one-visualization-be-connected-via-a-line-per-each-time-series/189125/1 "2019-07-05T14:31:58Z")
Hello,
I'm new to the Kibana environment and I did not manage to build the following visualization:
From several temperature sensors, the measured values are retrieved from a server and written to the Elasticsearch.
- Each document contains the unique sensor name, the time of measurement and the measured value. For each sensor there is only one document at a time of measurement.
- All documents are written to one index (iot\_sensor\_data).
- Addionally, there is an index per sensor into which only the documents of the associated sensor are written.
In Kibana I would like to have a visualization in which all temperature time series (x-axis: measuring time, y-axis: measured value) are included and the measured values are connected via a line.
- With the visualization 'Line' I get only the time series of a sensor as desired.
- In the 'Visual Builder' visualization, the measured values of the individual time series are not connected by a line.
Thanks for any help!
---
### Author:  [@lukeelmers](https://discuss.elastic.co/u/lukeelmers)
#### Post date: [July 5, 2019, 5:47pm UTC](https://discuss.elastic.co/t/how-can-the-measured-values-of-time-series-in-one-visualization-be-connected-via-a-line-per-each-time-series/189125/2 "2019-07-05T17:47:25Z")
Hi @bkruenelke - welcome!
To clarify, are you saying you are able to get the desired results in a `Line` visualization, but not in `Visual Builder`? Based on your description, I believe you should be able to accomplish what you are looking for as follows:
In `Visualize > Line`:
1. Y-Axis metric: Sum aggregation on the temperature value field
2. X-Axis bucket: date histogram on your recorded timestamp
3. Split Series bucket: Terms aggregation on the unique sensor name
In `Visualize > Visual Builder`:
1. In the `metrics` section of the `data` tab: Sum aggregation on the temperature value field
2. Group by `terms`, by field name for the unique sensor name
3. In the `panel options` tab: make sure you have selected your index pattern & time field
Which version of Kibana are you using?
---
### Author:  [@bkruenelke](https://discuss.elastic.co/u/bkruenelke)
#### Post date: [July 8, 2019, 8:49am UTC](https://discuss.elastic.co/t/how-can-the-measured-values-of-time-series-in-one-visualization-be-connected-via-a-line-per-each-time-series/189125/3 "2019-07-08T08:49:09Z")
Hi Luke,
yes, I got the desired result in a Line visualization, but only for one time series. With your advice (Split Series bucket), now I get all time series. Thank you!!!
But the advice according Visual Builder, did not work. I can’t take Sum aggregation. I’ll have to take Average aggregation. Then I get only points instead of lines:
· Data:
o Metrics
§ Aggregation: Average
§ Field: temperature value field
§ Group by: Terms
§ By: unique sensor name
§ Top: 25
§ Order by: Terms
§ Direction: Ascending
o Options:
§ Data Formatter: Number
§ Template: {{value}} °C
§ Filter: none
§ Chart type: Line
§ Stacked: None
§ Fill (0 to 1): 0
§ Line width: 1
§ Point size: 4
§ Steps: No
· Panel options
o Data
§ Index pattern: my index
§ Time field: recorded timestamp
§ Interval: auto
Do you have an idea?
Best regards,
Bernd Krünelke
---
### Author:  [@lukeelmers](https://discuss.elastic.co/u/lukeelmers)
#### Post date: [July 9, 2019, 8:08pm UTC](https://discuss.elastic.co/t/how-can-the-measured-values-of-time-series-in-one-visualization-be-connected-via-a-line-per-each-time-series/189125/4 "2019-07-09T20:08:04Z")
> [@bkruenelke](#):
>
> § Chart type: Line
>
> § Stacked: None
>
> § Fill (0 to 1): 0
>
> § Line width: 1
>
> § Point size: 4
>
> § Steps: No
Hm, yeah with these settings above I'm not sure what would be going on. You should be getting a chart with lines connecting the points, but no fill.
What version of the Elastic Stack are you running? I'm not able to reproduce this on the version I'm testing currently `7.1.1`... everything renders as expected. Here's what I'm seeing using some of the `kibana_sample_data_logs` demo data that ships with Kibana.
---
### Author:  [@bkruenelke](https://discuss.elastic.co/u/bkruenelke)
#### Post date: [July 10, 2019, 7:14am UTC](https://discuss.elastic.co/t/how-can-the-measured-values-of-time-series-in-one-visualization-be-connected-via-a-line-per-each-time-series/189125/5 "2019-07-10T07:14:18Z")
Hi Luke,
I’m running 7.1.1.
What happens, if you change the aggregation from Sum to Average, Min or Max? Sum is not suitable in this case.
Best Regards
Bernd
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 7, 2019, 7:14am UTC](https://discuss.elastic.co/t/how-can-the-measured-values-of-time-series-in-one-visualization-be-connected-via-a-line-per-each-time-series/189125/6 "2019-08-07T07:14:21Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.