# Value not greater 20% of the average value of the same job

**URL:** <https://discuss.elastic.co/t/value-not-greater-20-of-the-average-value-of-the-same-job/310832>\
**Category:** Kibana\
**Created:** [July 28, 2022, 8:18am UTC](https://discuss.elastic.co/t/value-not-greater-20-of-the-average-value-of-the-same-job/310832 "2022-07-28T08:18:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![eddieyee](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/eddieyee/32/98119_2.png) [@eddieyee](https://discuss.elastic.co/u/eddieyee)\
**Post date:** [July 28, 2022, 8:18am UTC](https://discuss.elastic.co/t/value-not-greater-20-of-the-average-value-of-the-same-job/310832/1 "2022-07-28T08:18:42Z")

</div>

Hi I'm trying to create a data table as seem in the screenshot below.

Basically I need to compare the current document duration field value not higher than 20% of the average duration of the same job.

Have tried using Lens, TSVB and Aggregate based data table but was not able to get the result I want.

 ![sxyUvgE1](https://us1.discourse-cdn.com/elastic/original/3X/7/6/765e2de8022462bb88d0a8219c6f4ce35dd8096a.png)

---

<div class="post-metadata">

**Author:** ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)\
**Post date:** [August 12, 2022, 7:29am UTC](https://discuss.elastic.co/t/value-not-greater-20-of-the-average-value-of-the-same-job/310832/2 "2022-08-12T07:29:40Z")

</div>

I think you could only achieve it with Vega, but it's not a trivial problem.

---

<div class="post-metadata">

**Author:** ![eddieyee](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/eddieyee/32/98119_2.png) [@eddieyee](https://discuss.elastic.co/u/eddieyee)\
**Post date:** [August 18, 2022, 6:23am UTC](https://discuss.elastic.co/t/value-not-greater-20-of-the-average-value-of-the-same-job/310832/3 "2022-08-18T06:23:11Z")

</div>

Thanks Marta!

---

<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:** [September 15, 2022, 6:23am UTC](https://discuss.elastic.co/t/value-not-greater-20-of-the-average-value-of-the-same-job/310832/4 "2022-09-15T06:23:37Z")

</div>

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