# Create an historical **URL:** \ **Category:** Kibana\ **Created:** [April 17, 2018, 7:16am UTC](https://discuss.elastic.co/t/create-an-historical/128301 "2018-04-17T07:16:03Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![marie](https://avatars.discourse-cdn.com/v4/letter/m/bc8723/32.png) [@marie](https://discuss.elastic.co/u/marie)\ **Post date:** [April 17, 2018, 7:16am UTC](https://discuss.elastic.co/t/create-an-historical/128301/1 "2018-04-17T07:16:04Z")
Hi, I want to create an historical with kibana. For example, in my Json I want to change many fields for an ID always rest the same. And Day by day we can show the differents changing. I have insert this differents lines for testing but kibana count many times the line and not only once. It is really possible or not ? Thanks for your help ---
**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\ **Post date:** [April 17, 2018, 6:03pm UTC](https://discuss.elastic.co/t/create-an-historical/128301/2 "2018-04-17T18:03:24Z")
I'm not understanding what you mean here. Can you give more details as to what you're wanting to accomplish, maybe even including screenshots or sketches? Thanks! ---
**Author:** ![marie](https://avatars.discourse-cdn.com/v4/letter/m/bc8723/32.png) [@marie](https://discuss.elastic.co/u/marie)\ **Post date:** [April 18, 2018, 7:42am UTC](https://discuss.elastic.co/t/create-an-historical/128301/3 "2018-04-18T07:42:13Z")
Yes, I will explain a little more. ![Capture](https://us1.discourse-cdn.com/elastic/original/3X/3/e/3eda4f42123359025d96ed9dff27739ead04984c.PNG) Here I have for the same ID or UUID, 2 lines. The first with just a timestamp and a output index and the second with more fields. Now I want for an other line the same ID or UUID but with a timestamp differents and maybe other fields differents like timestamp at the 20th April. Kibana will delete the line at the 19th and keep the line at the 20th, but I want the both lines, for have always the differents step of this ID or UUID. Sorry, I'm not sure about my explanation is very clearly or my English is very correct. ---
**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\ **Post date:** [April 18, 2018, 3:46pm UTC](https://discuss.elastic.co/t/create-an-historical/128301/4 "2018-04-18T15:46:07Z")
What do you mean by "Kibana will delete the line at the 19th and keep the line at the 20th"? Kibana shouldn't be deleting any of your data. ---
**Author:** ![marie](https://avatars.discourse-cdn.com/v4/letter/m/bc8723/32.png) [@marie](https://discuss.elastic.co/u/marie)\ **Post date:** [April 19, 2018, 8:38am UTC](https://discuss.elastic.co/t/create-an-historical/128301/5 "2018-04-19T08:38:38Z")
I have add a line today which is ![2](https://us1.discourse-cdn.com/elastic/original/3X/3/a/3af20d15494d76ded2cadef0dc6b566ce1dd0335.PNG) I add the same line at tommorow and the first disappear and it rest the last line load ![3](https://us1.discourse-cdn.com/elastic/original/3X/7/4/7474b746ff45f15cb398de1b707f2542ffb63631.PNG) ![4](https://us1.discourse-cdn.com/elastic/original/3X/0/b/0bed36b898ef9a537c3ab8ee9c9df26b973b9610.PNG) Here we can see that, the first line dosn't exist anymore. However I want see the both lines and if I add the same line many times in the same day but at differents hours, I want Kibana count only once the line with the same ID in the day. And by this means have an historical like a table of historisation in SQL you know what I mean like that? ---
**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\ **Post date:** [April 23, 2018, 8:40pm UTC](https://discuss.elastic.co/t/create-an-historical/128301/6 "2018-04-23T20:40:33Z")
Seems to me that you're updating the original record instead of storing a new record. Because you're doing this, the original record is lost (even in Elasticsearch). Why not just store a new record instead of updating the original? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 21, 2018, 8:40pm UTC](https://discuss.elastic.co/t/create-an-historical/128301/7 "2018-05-21T20:40:35Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.