# Help to constructing visualization

**URL:** <https://discuss.elastic.co/t/help-to-constructing-visualization/169567>\
**Category:** Kibana\
**Created:** [February 22, 2019, 11:29am UTC](https://discuss.elastic.co/t/help-to-constructing-visualization/169567 "2019-02-22T11:29:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jorjao](https://avatars.discourse-cdn.com/v4/letter/j/7bcc69/32.png) [@jorjao](https://discuss.elastic.co/u/jorjao)\
**Post date:** [February 22, 2019, 11:29am UTC](https://discuss.elastic.co/t/help-to-constructing-visualization/169567/1 "2019-02-22T11:29:39Z")

</div>

I'm new in Kibana.  
My data is that of tasks in which I indicate the start date, expected date of closure (due) and the end date.

 ![tarefas](https://us1.discourse-cdn.com/elastic/original/3X/d/7/d76a196071dd4e06fe3d6ad51f1e437d32d6cc6e.png)

I need to build a visualization that tells me the percentage of tasks that met the deadline per month.  
In other words, I needed to know the total number of tasks that fulfilled the deadline and to divide by all the tasks that were closed that month.  
How can I do this in visualization?  
I have already been able to do both counts using different metrics but how to divide one by the other and only show this separate value per month?

 ![tarefas_visualize](https://us1.discourse-cdn.com/elastic/original/3X/e/3/e3988ad38e2f628b430b066a437f24532e60a965.png)

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [February 22, 2019, 11:53am UTC](https://discuss.elastic.co/t/help-to-constructing-visualization/169567/2 "2019-02-22T11:53:22Z")

</div>

You can do the division and display per month by using TSVB. The interface of the builder is similar and for calculating the percentages you should used the Math aggregation (which is only available in TSVB)

---

<div class="post-metadata">

**Author:** ![jorjao](https://avatars.discourse-cdn.com/v4/letter/j/7bcc69/32.png) [@jorjao](https://discuss.elastic.co/u/jorjao)\
**Post date:** [February 25, 2019, 9:27am UTC](https://discuss.elastic.co/t/help-to-constructing-visualization/169567/3 "2019-02-25T09:27:51Z")

</div>

Thanks for your response.  
I need a help in two questions.  
1 - I constroy two visualization and in third i will use math aggregation but this option is disabled.  
I only have the options (metric aggregations) available.  
what i do wrong? how enable math aggreation.

 ![disabled](https://us1.discourse-cdn.com/elastic/original/3X/d/9/d9645498567388fec87f2ea99ef4167200efbccc.png)

2 - how use filter in date field? I use aggregation count and i need filter endTime if have value. I use the expression endTime: "exists", but the result is 0 (wrong because tasks have endTime).  
how filter?

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

---

<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:** [March 25, 2019, 9:27am UTC](https://discuss.elastic.co/t/help-to-constructing-visualization/169567/4 "2019-03-25T09:27:54Z")

</div>

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