# Do operations without timeline

**URL:** <https://discuss.elastic.co/t/do-operations-without-timeline/102722>\
**Category:** Kibana\
**Created:** [October 4, 2017, 3:21pm UTC](https://discuss.elastic.co/t/do-operations-without-timeline/102722 "2017-10-04T15:21:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![afonso.ribeiro](https://avatars.discourse-cdn.com/v4/letter/a/a88e57/32.png) [@afonso.ribeiro](https://discuss.elastic.co/u/afonso.ribeiro)\
**Post date:** [October 4, 2017, 3:21pm UTC](https://discuss.elastic.co/t/do-operations-without-timeline/102722/1 "2017-10-04T15:21:40Z")

</div>

Hi everyone,

I have a doubt about kibana. I have a table and a graph in excel and I am trying to transpose to elastic.

The table below shows the sum of M variable in the last column. The same think happens to the X variable.

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

Now what I need is to divide both and compare the differences of each of them, as you can see in the graph below.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/4/547140e88f52065dd097a9c6e1be8c4e6e3a45fa.png)

Is this possible in kibana?

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [October 4, 2017, 3:39pm UTC](https://discuss.elastic.co/t/do-operations-without-timeline/102722/2 "2017-10-04T15:39:53Z")

</div>

To help here, I'm going to need to see some sample documents inside your dataset, if that's possible.

---

<div class="post-metadata">

**Author:** ![afonso.ribeiro](https://avatars.discourse-cdn.com/v4/letter/a/a88e57/32.png) [@afonso.ribeiro](https://discuss.elastic.co/u/afonso.ribeiro)\
**Post date:** [October 4, 2017, 4:23pm UTC](https://discuss.elastic.co/t/do-operations-without-timeline/102722/3 "2017-10-04T16:23:59Z")

</div>

Yes. Of course.

This is an example of a BD that feeds the table.

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

If enterprise is "Website" then it sums total\_abord to A variable.  
If enterprise is "Call center" then it sums total\_abord to CC variable.

But for example. To the G and F variables the DB can be other.

Is this making sense to you?

Thanks very much

---

<div class="post-metadata">

**Author:** ![afonso.ribeiro](https://avatars.discourse-cdn.com/v4/letter/a/a88e57/32.png) [@afonso.ribeiro](https://discuss.elastic.co/u/afonso.ribeiro)\
**Post date:** [October 4, 2017, 4:26pm UTC](https://discuss.elastic.co/t/do-operations-without-timeline/102722/4 "2017-10-04T16:26:13Z")

</div>

I know that timelion can do some operations. But in this case, as you can see in the graph, the x-axis is not date/time format and I can't change x-axis in timelion

---

<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 1, 2017, 4:26pm UTC](https://discuss.elastic.co/t/do-operations-without-timeline/102722/5 "2017-11-01T16:26:16Z")

</div>

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