# Is it possible to make tables like in Excel? **URL:** \ **Category:** Kibana\ **Created:** [April 24, 2020, 12:26pm UTC](https://discuss.elastic.co/t/is-it-possible-to-make-tables-like-in-excel/229652 "2020-04-24T12:26:19Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Oggy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/oggy/32/65184_2.png) [@Oggy](https://discuss.elastic.co/u/Oggy)\ **Post date:** [April 24, 2020, 12:26pm UTC](https://discuss.elastic.co/t/is-it-possible-to-make-tables-like-in-excel/229652/1 "2020-04-24T12:26:20Z")
What I am interested in is replicating the look and functionality of excel sheets. So I would like a way for me to be able to set some columns do mathematical caculations on other fields, and to be able to simply chose a column in whom I can set fields manually. Can that be done in Kibana using visualizations or do I need a plugin or some other tool to do it. This picture is an example of what I mean. ![image004(1)](https://us1.discourse-cdn.com/elastic/original/3X/c/e/cea1bdf8d7854ac441ede01b2076295665d561a7.jpeg) ---
**Author:** ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)\ **Post date:** [April 24, 2020, 12:52pm UTC](https://discuss.elastic.co/t/is-it-possible-to-make-tables-like-in-excel/229652/2 "2020-04-24T12:52:18Z")
Hello @Oggy, Have you looked at using the data table visualization? [https://www.elastic.co/guide/en/kibana/current/visualize.html](https://www.elastic.co/guide/en/kibana/current/visualize.html) Thanks, Matt ---
**Author:** ![Oggy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/oggy/32/65184_2.png) [@Oggy](https://discuss.elastic.co/u/Oggy)\ **Post date:** [April 30, 2020, 10:17am UTC](https://discuss.elastic.co/t/is-it-possible-to-make-tables-like-in-excel/229652/3 "2020-04-30T10:17:36Z")
I have but that does not solve my issue. I want to be able to have manual fields and do basic math operations. Is it doable with scripted fields ? ---
**Author:** ![balaji\_18](https://avatars.discourse-cdn.com/v4/letter/b/bbce88/32.png) [@balaji\_18](https://discuss.elastic.co/u/balaji_18)\ **Post date:** [April 30, 2020, 10:30am UTC](https://discuss.elastic.co/t/is-it-possible-to-make-tables-like-in-excel/229652/4 "2020-04-30T10:30:14Z")
Hi Oggy, can you please try [https://github.com/fbaligand/kibana-enhanced-table](https://github.com/fbaligand/kibana-enhanced-table), this plugin do mathematical caculations ---
**Author:** ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)\ **Post date:** [April 30, 2020, 11:37am UTC](https://discuss.elastic.co/t/is-it-possible-to-make-tables-like-in-excel/229652/5 "2020-04-30T11:37:58Z")
> [@Oggy](#): > > I have but that does not solve my issue. > I want to be able to have manual fields and do basic math operations. > Is it doable with scripted fields ? Its depends on the precise definition of what you need to do and what your documents look like. ---
**Author:** ![Oggy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/oggy/32/65184_2.png) [@Oggy](https://discuss.elastic.co/u/Oggy)\ **Post date:** [May 7, 2020, 7:28am UTC](https://discuss.elastic.co/t/is-it-possible-to-make-tables-like-in-excel/229652/6 "2020-05-07T07:28:45Z")
Okay to make it more clear. The indexes we use have price for every order made. What I should try to do is to compare the total sum of the field to a static value (that we do not have in the logs) and to see how much percentage the current sum is lower or higher from the static value. That static value I don't have in the logs and it is different for every product. Adding new fields in code to do that is a bad practice, so is there a Kibana way of doing that? These static fields are basically projected earnings, and we have too many products we have to do this for. Could I make a new field in Kibana and give them a value manually ? ---
**Author:** ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)\ **Post date:** [May 7, 2020, 2:34pm UTC](https://discuss.elastic.co/t/is-it-possible-to-make-tables-like-in-excel/229652/7 "2020-05-07T14:34:51Z")
I think the best approach for a problem like this is to think in terms of elasticsearch. If you can think about documents, values in those documents, and how you might query them then the Kibana portion becomes easy. If I understand correctly, you have a set of logs that become documents in elasticsearch but they lack a value that is necessary for the calculation you need. Where does that value live? How do you find it? How are your logs being ingested into elasticsearch? I suspect we need to find a way to populate that field either when the log line is ingested or add it later. ---
**Author:** ![Oggy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/oggy/32/65184_2.png) [@Oggy](https://discuss.elastic.co/u/Oggy)\ **Post date:** [May 11, 2020, 12:57pm UTC](https://discuss.elastic.co/t/is-it-possible-to-make-tables-like-in-excel/229652/8 "2020-05-11T12:57:33Z")
That static value is set revenue goal, and we do not want to send it to Kibana. What I was asking is simply if I can make a visualization (as a table) that tells me how much percentage I am currently at (when compared to the set revenue goal). For example lets say our goal is 1000, we currently have 10. The field should say we have only reached 10% of our set goal. ---
**Author:** ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)\ **Post date:** [May 18, 2020, 8:43pm UTC](https://discuss.elastic.co/t/is-it-possible-to-make-tables-like-in-excel/229652/9 "2020-05-18T20:43:22Z")
How many items have revenue goals? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 15, 2020, 8:43pm UTC](https://discuss.elastic.co/t/is-it-possible-to-make-tables-like-in-excel/229652/10 "2020-06-15T20:43:26Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.