# Create New Index for Line Plot

**URL:** <https://discuss.elastic.co/t/create-new-index-for-line-plot/198136>\
**Category:** Kibana\
**Created:** [September 5, 2019, 1:40am UTC](https://discuss.elastic.co/t/create-new-index-for-line-plot/198136 "2019-09-05T01:40:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nastooh](https://avatars.discourse-cdn.com/v4/letter/n/77aa72/32.png) [@Nastooh](https://discuss.elastic.co/u/Nastooh)\
**Post date:** [September 5, 2019, 1:40am UTC](https://discuss.elastic.co/t/create-new-index-for-line-plot/198136/1 "2019-09-05T01:40:17Z")

</div>

Hi  
On Kibana 6.2.3, I am receving json records that look like "{"A\_1":1234}","{"A\_2":5678}", etc. I would like to change these - in order to plot them - to "{"A":"1","V":1234}", "{"A":"2","V":5678}, ... . I've been experimenting with scripted field, but with not much luck. Any help would be appreciated.  
Cheers,

---

<div class="post-metadata">

**Author:** ![tylersmalley](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tylersmalley/32/8833_2.png) [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)\
**Post date:** [September 5, 2019, 7:54pm UTC](https://discuss.elastic.co/t/create-new-index-for-line-plot/198136/2 "2019-09-05T19:54:45Z")

</div>

Your best option here is going to be to change the format which the data is stored in to best represent how you want to access it. Even if you were able to get a scripted field to work, it's going to be highly inefficient due to it needing to read each document.

You can re-index this data using a script tag to achieve the format you want, but will have to update how you're inserting the data. You can also use something like [Logstash](https://www.elastic.co/products/logstash) or [Pipelines](https://www.elastic.co/guide/en/elasticsearch/reference/current/pipeline.html) to modify the data as it's coming into Elasticsearch.

---

<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:** [October 3, 2019, 7:54pm UTC](https://discuss.elastic.co/t/create-new-index-for-line-plot/198136/3 "2019-10-03T19:54:47Z")

</div>

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