# More complicated calculation/visualisaton - is it possible?

**URL:** <https://discuss.elastic.co/t/more-complicated-calculation-visualisaton-is-it-possible/309136>\
**Category:** Kibana\
**Created:** [July 7, 2022, 5:53pm UTC](https://discuss.elastic.co/t/more-complicated-calculation-visualisaton-is-it-possible/309136 "2022-07-07T17:53:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Frantisek\_Sitler](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/frantisek_sitler/32/108041_2.png) [@Frantisek\_Sitler](https://discuss.elastic.co/u/Frantisek_Sitler)\
**Post date:** [July 7, 2022, 5:53pm UTC](https://discuss.elastic.co/t/more-complicated-calculation-visualisaton-is-it-possible/309136/1 "2022-07-07T17:53:21Z")

</div>

Hello,  
I have an issue to create a bit more complex calculation and visualization. It should take data from multiple indices, always an record will be connected via one field - IN number.  
There is always multiple records with that number, recording status changes. I need to create some table or visualization, where it will be visible how IN went through statuses and when it changed status and how long it stayed in each.  
Is it possible to achieve it?  
Ie sample data is:

Number: IN2020  
Time: 15.1.2020 12:20.00  
Action: update  
New status: created  
Message; xxx

Number: IN2020  
Time: 15.1.2020 12:40.00  
Action: update  
New status: assigned  
Message; xxx

Number: IN2020  
Time: 15.1.2020 13:40.00  
Action: in progress  
New status: created  
Message; xxx

Number: IN2020  
Time: 18.1.2020 12:20.00  
Action: update  
New status: closed  
Message; xxx

And from that, I need to get a timeline with times. For sure, there will be much more IN numbers, so it has to be like a template which will automatically generate the info.  
Later on, I will need to extend it with some other data from another index and calculate with some extra times, but... later on.

Does anybody have an idea how to achieve that?

Thanks

---

<div class="post-metadata">

**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:** [July 7, 2022, 7:52pm UTC](https://discuss.elastic.co/t/more-complicated-calculation-visualisaton-is-it-possible/309136/2 "2022-07-07T19:52:52Z")

</div>

Hi @Frantisek_Sitler ,

To use Elasticsearch data in Kibana, you first [create a data view](https://www.elastic.co/guide/en/kibana/current/data-views.html). The data view you create can match multiple indices, so that should cover your first requirement.

A [saved search in Discover](https://www.elastic.co/guide/en/kibana/current/save-open-search.html) might get you close to that sequential table you described. They can also be embedded on a dashboard.

As for creating a table to follow the progress of a particular IN series, I would use [Kibana Lens](https://www.elastic.co/guide/en/kibana/current/lens.html).

You should be able to add a filter to only get the documents with a particular ID  
number

 ![Screen Shot 2022-07-07 at 2.00.52 PM](https://us1.discourse-cdn.com/elastic/original/3X/c/d/cd0a6aca64c72ad3d8665002d1095bac5d7e43c0.png)

Let me know if this helps.

---

<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:** [August 4, 2022, 7:53pm UTC](https://discuss.elastic.co/t/more-complicated-calculation-visualisaton-is-it-possible/309136/3 "2022-08-04T19:53:25Z")

</div>

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