# Complex calculations and table view format **URL:** \ **Category:** Kibana\ **Created:** [February 12, 2020, 4:38pm UTC](https://discuss.elastic.co/t/complex-calculations-and-table-view-format/219045 "2020-02-12T16:38:45Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![nino](https://avatars.discourse-cdn.com/v4/letter/n/b9bd4f/32.png) [@nino](https://discuss.elastic.co/u/nino)\ **Post date:** [February 12, 2020, 4:38pm UTC](https://discuss.elastic.co/t/complex-calculations-and-table-view-format/219045/1 "2020-02-12T16:38:46Z")
Hello all, i would like to know if this kind of tables can be done with kibana and add it to a dasboard. What is the best approach to achieve this? **Index structure** ``` { "gain_loss" => " 1,011.53", "@timestamp" => 2020-01-06T23:00:00.000Z } ``` **Goal** : make calculations over gain\_loss field and create a view in table/s format like this: ``` Daily basis Sum positives: 1000 Sum negatives: -3000 Sum positives / Sum negatives ratio: 0,33 Max positive: 1300 Max negative: -2000 Avg: 200 Monthly basis Sum positives: 3000 Sum negatives: -6000 Sum positives / Sum negatives ratio: 0,5 Max positive: 2000 Max negative: -3000 Avg: 700 ``` Best regards ---
**Author:** ![nino](https://avatars.discourse-cdn.com/v4/letter/n/b9bd4f/32.png) [@nino](https://discuss.elastic.co/u/nino)\ **Post date:** [February 13, 2020, 8:20am UTC](https://discuss.elastic.co/t/complex-calculations-and-table-view-format/219045/2 "2020-02-13T08:20:44Z")
Hello all, Any ideas?. Maybe my question it is not clear. Best regards ---
**Author:** ![myasonik](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/myasonik/32/62369_2.png) [@myasonik](https://discuss.elastic.co/u/myasonik)\ **Post date:** [February 13, 2020, 9:57pm UTC](https://discuss.elastic.co/t/complex-calculations-and-table-view-format/219045/3 "2020-02-13T21:57:53Z")
Hey @nino! Should be doable! Some tips: - Looks like you might be indexing a number as a string — this will make math difficult to impossible. - Create two visualizations when trying to compare two time periods then you can compare them side-by-side in a dashboard - To find “positives” and “negatives”, use `Filters` or `Filter Ratio` . For example, `Max(gain_loss)` with a filter `gain_loss>0` would be max positives. - You can setup time filters in the table itself or in the dashboard you can change the time range for individual panels (independent of the global time range) Edit: Previously this comment said it wasn't possible but on second thought you should be able to with the above tips! ---
**Author:** ![nino](https://avatars.discourse-cdn.com/v4/letter/n/b9bd4f/32.png) [@nino](https://discuss.elastic.co/u/nino)\ **Post date:** [February 14, 2020, 9:21am UTC](https://discuss.elastic.co/t/complex-calculations-and-table-view-format/219045/4 "2020-02-14T09:21:42Z")
Thank you so much @myasonik, yes i used filter ratio to achieve this but what is really a pain is to create a table with all the calculations to add it in a dashboard. What about the view? I've tried TSVB and markdown but you can only add two calculations. gain\_loss is a numeric field **View 1 (statistics over the field gain\_loss in a daily basis)** ``` Sum positives: 1000 Sum negatives: -3000 Sum positives / Sum negatives ratio: 0,33 Max positive: 1300 Max negative: -2000 Avg: 200 ``` **View 2 (stats over the field gail\_loss in a monthly basis)** ``` Sum positives: 1000 Sum negatives: -3000 Sum positives / Sum negatives ratio: 0,33 Max positive: 1300 Max negative: -2000 Avg: 200 ``` No way to add more than too calculations with TSVB. Any more ideas to work around this? ![tsvb](https://us1.discourse-cdn.com/elastic/original/3X/8/8/88a4e8d617ac2ced9bf95e338e02f4b6dd845a40.jpeg) ---
**Author:** ![myasonik](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/myasonik/32/62369_2.png) [@myasonik](https://discuss.elastic.co/u/myasonik)\ **Post date:** [February 14, 2020, 9:15pm UTC](https://discuss.elastic.co/t/complex-calculations-and-table-view-format/219045/5 "2020-02-14T21:15:30Z")
Hmmm... I believe your ratio cell won't be possible inside of Kibana at the moment as there's no way to compute one cell off of another cell. You might want to look into some pivot table plugins for Kibana (of which there are multiple) which might make creating something like this easier. ---
**Author:** ![nino](https://avatars.discourse-cdn.com/v4/letter/n/b9bd4f/32.png) [@nino](https://discuss.elastic.co/u/nino)\ **Post date:** [February 15, 2020, 8:27am UTC](https://discuss.elastic.co/t/complex-calculations-and-table-view-format/219045/6 "2020-02-15T08:27:17Z")
Thank you @myasonik, maybe i have to abandon kibana for visualization. I think kibana is very limited when you want to make a dashboard a bit more sophisticated. I need to make computations over the series like R or Python way, drawdowns, ratios, monthlies, dailies. Any ideas to face this with kibana or alternative to replace kibana? ---
**Author:** ![nino](https://avatars.discourse-cdn.com/v4/letter/n/b9bd4f/32.png) [@nino](https://discuss.elastic.co/u/nino)\ **Post date:** [March 5, 2020, 8:57am UTC](https://discuss.elastic.co/t/complex-calculations-and-table-view-format/219045/7 "2020-03-05T08:57:09Z")
Dear all, do you know an alternative to kibana to replace the visualization part of an ELK?. I need to achieve visualizations like: **Table of metrics (without timestamp)** ``` +-----------------+-------+ | Metric | Value | +-----------------+-------+ | Net performance | 1000 | | Drawdown | -200 | | Positives | 20 | | Negatives | 10 | | Ratio | 0.50 | +-----------------+-------+ ``` Maybe, creating this table out of kibana? Creating and index with this structure and then send it to elastic? ``` { "Net performance" => "1000", "Drawdown" => "200", "Positives" => "20", "Negatives" => "10", "Ratio" => "0.50", } ``` Maybe not efficient to create this out of kibana because i have to read the whole data when a new data point arrives, but i don't know how to make computations on the fly with kibana. What do you think? **Metrics and Calculates fields** How do you calculate metrics or fields based on document fields?, for example the drawdown. Did you make the computations befofe sending the index to elastic?. For example, make the calculations in a logstash pipeline. I need to know the way to go with this kind of issues. Best regards, Vince. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 2, 2020, 9:08am UTC](https://discuss.elastic.co/t/complex-calculations-and-table-view-format/219045/8 "2020-04-02T09:08:22Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.