# Visualization by STATUS field which changes his state

**URL:** <https://discuss.elastic.co/t/visualization-by-status-field-which-changes-his-state/251071>\
**Category:** Kibana\
**Created:** [October 6, 2020, 5:54am UTC](https://discuss.elastic.co/t/visualization-by-status-field-which-changes-his-state/251071 "2020-10-06T05:54:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ahmadsayeed3](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmadsayeed3/32/72888_2.png) [@ahmadsayeed3](https://discuss.elastic.co/u/ahmadsayeed3)\
**Post date:** [October 6, 2020, 5:54am UTC](https://discuss.elastic.co/t/visualization-by-status-field-which-changes-his-state/251071/1 "2020-10-06T05:54:21Z")

</div>

Hi,

I recently started working on Kibana visualization so I know very less about it.  
Allow me to explain my use case.

I have a STATUS field which has 4 states. In-Queue, In-Progress, Completed and Purged.  
In parallel multiple document inserts into Elasticsearch and their first state is In-Queue.

Once they completed the job, STATUS field value updates to 'Completed'. At the the end of the day there will be no state of In-Queue/In-Progress only Completed/Purged.

Now I need to show line chart. What time number of In-progress/In-queue job increased and decreased. Similar like memory chart which shows what time memory increased and decreased.

But In my document at the end there is no in-progress/in-queue state, they updates to 'completed'. And their count always be zero.

I don't know to converts this into visualization.

This how my data looks like.

```auto
   {
        "queue_end_time" : "2020:09:25 08:42:21.516",
        "queue_start_time" : "2020:09:25 08:41:48.860",
        "job_end_time" : "2020:09:25 08:42:44.309",
        "job_start_time" : "2020:09:25 08:41:48.860",
        "status" : "purged", in-queue/in-progress/completed
    }

```

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/7/974862a8feec21e3f240c4e107b56b2f69187423.png)

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [October 6, 2020, 12:08pm UTC](https://discuss.elastic.co/t/visualization-by-status-field-which-changes-his-state/251071/2 "2020-10-06T12:08:07Z")

</div>

How are the documents being updated?

Are you creating new records or updating the existing one?

---

<div class="post-metadata">

**Author:** ![ahmadsayeed3](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmadsayeed3/32/72888_2.png) [@ahmadsayeed3](https://discuss.elastic.co/u/ahmadsayeed3)\
**Post date:** [October 6, 2020, 12:20pm UTC](https://discuss.elastic.co/t/visualization-by-status-field-which-changes-his-state/251071/3 "2020-10-06T12:20:00Z")

</div>

updating the existing field: STATUS.

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [October 6, 2020, 12:31pm UTC](https://discuss.elastic.co/t/visualization-by-status-field-which-changes-his-state/251071/4 "2020-10-06T12:31:33Z")

</div>

@ahmadsayeed3 that is most likely the reason. The record doesn't maintain the status overtime and will only show you the last value. If you want to create a line chart over time like shown you would need to create a new record for each time you bring in the data.

---

<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:** [November 3, 2020, 12:32pm UTC](https://discuss.elastic.co/t/visualization-by-status-field-which-changes-his-state/251071/5 "2020-11-03T12:32:21Z")

</div>

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