# Enhanced Table computed column issue

**URL:** <https://discuss.elastic.co/t/enhanced-table-computed-column-issue/269000>\
**Category:** Kibana\
**Created:** [April 1, 2021, 8:59am UTC](https://discuss.elastic.co/t/enhanced-table-computed-column-issue/269000 "2021-04-01T08:59:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![bab](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bab/32/86201_2.png) [@bab](https://discuss.elastic.co/u/bab)\
**Post date:** [April 1, 2021, 8:59am UTC](https://discuss.elastic.co/t/enhanced-table-computed-column-issue/269000/1 "2021-04-01T08:59:18Z")

</div>

i'm trying to get the duration in s using the formula but is not working, can someone help pls, thank you.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/d/cdf38c992077c62c7d913915494d300f7aba6b44.png)

---

<div class="post-metadata">

**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\
**Post date:** [April 1, 2021, 1:18pm UTC](https://discuss.elastic.co/t/enhanced-table-computed-column-issue/269000/2 "2021-04-01T13:18:59Z")

</div>

Hi, unfortunately the Enhanced Table plugin is a third-party plugin and we don't support it directly.  
You can try to ask [Discussions · fbaligand/kibana-enhanced-table · GitHub](https://github.com/fbaligand/kibana-enhanced-table/discussions)  
I'm not familiar with this plugin but looks like it is cannot pick up the two date columns correctly.  
You probably could just check what is going on if the `Format` the computed column is just a string or number, to see if the actual difference is computed. If you see something like a milliseconds number then the problem is with the pattern applied, if you still see `NaN` it looks like the formula is wrong or the code can't detect the two columns as dates.

---

<div class="post-metadata">

**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\
**Post date:** [April 1, 2021, 1:19pm UTC](https://discuss.elastic.co/t/enhanced-table-computed-column-issue/269000/3 "2021-04-01T13:19:21Z")

</div>

cc @fbaligand

---

<div class="post-metadata">

**Author:** ![fbaligand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fbaligand/32/5657_2.png) [@fbaligand](https://discuss.elastic.co/u/fbaligand)\
**Post date:** [April 2, 2021, 6:27pm UTC](https://discuss.elastic.co/t/enhanced-table-computed-column-issue/269000/4 "2021-04-02T18:27:36Z")

</div>

Hi,

I just tested with enhanced table last version (V1.11), and it works fine.  
I can do "col3 - col1", given that col3 and col1 have "date" mapping.  
Do you use "Enhanced Table" or "Document Table" visualization ?  
Maybe you could upgrade to last Enhanced Table plugin ?

By the way, as the result is a "duration", and not a "date", I invite you to use "Number" in "Format" field.

---

<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:** [April 30, 2021, 6:28pm UTC](https://discuss.elastic.co/t/enhanced-table-computed-column-issue/269000/5 "2021-04-30T18:28:28Z")

</div>

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