# Plotting time diff based on uniq thread\_id and API

**URL:** https://discuss.elastic.co/t/plotting-time-diff-based-on-uniq-thread-id-and-api/219157
**Category:** Kibana
**Created:** [February 13, 2020, 8:36am UTC](https://discuss.elastic.co/t/plotting-time-diff-based-on-uniq-thread-id-and-api/219157 "2020-02-13T08:36:56Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![kolli\_dilip](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kolli_dilip/32/33821_2.png) [@kolli\_dilip](https://discuss.elastic.co/u/kolli_dilip)
#### Post date: [February 13, 2020, 8:58am UTC](https://discuss.elastic.co/t/plotting-time-diff-based-on-uniq-thread-id-and-api/219157/4 "2020-02-13T08:58:01Z")

</div>

hi Pranesh,

you can refer to the below for idea

> [@Add a new filed in csv based on a value in colum and cal the time diff](https://discuss.elastic.co/t/add-a-new-filed-in-csv-based-on-a-value-in-colum-and-cal-the-time-diff/196117):
>
> Hi all I have a set of csv data as below [image] i am interested in adding a new field 'status' based on the 'endtime' column value, i.e if its not 'null' then the status should be completed else open. also need to calculate the timedifference between 'endtime' and 'createtime' if the endtime value is not 'null' and then add a new field 'timetaken' can any one help me on this Thanks

Reagrds  
dilip

---

_[View the full topic](https://discuss.elastic.co/t/plotting-time-diff-based-on-uniq-thread-id-and-api/219157)._