# Edit a personal metric by kibana

**URL:** <https://discuss.elastic.co/t/edit-a-personal-metric-by-kibana/94865>\
**Category:** Kibana\
**Created:** [July 27, 2017, 8:31pm UTC](https://discuss.elastic.co/t/edit-a-personal-metric-by-kibana/94865 "2017-07-27T20:31:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![marwa](https://avatars.discourse-cdn.com/v4/letter/m/67e7ee/32.png) [@marwa](https://discuss.elastic.co/u/marwa)\
**Post date:** [July 27, 2017, 8:31pm UTC](https://discuss.elastic.co/t/edit-a-personal-metric-by-kibana/94865/1 "2017-07-27T20:31:13Z")

</div>

Hi ,i am trying to create visualizations with kibana but when i want to use metrics i had just found a classical ones such as sum , average, min ,max... my question is if for example i had in a document a field called quantity and a field called price\_unit and i want to use a metric that calculates the revenue = quantity \* price\_unit can i edit this metric by kibana or not ??? any help please !!!

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [July 27, 2017, 9:02pm UTC](https://discuss.elastic.co/t/edit-a-personal-metric-by-kibana/94865/2 "2017-07-27T21:02:40Z")

</div>

You could achieve this by using the Advanced Json input for Kibana charts. Here, I could link you to a more detailed discussion on advanced Json input. It will query Elasticsearch for the data, and then the formula is performed in the script based on the values from elasticsearch. Feel free to come back with more questions if you have.

Thanks  
Rashmi

> [@JSON Input for Kibana charts](https://discuss.elastic.co/t/json-input-for-kibana-charts/290/9):
>
> Is it right that these JSON input parameters cannot do any real searches in elasticsearch then? We are trying to secure a user's Kibana instance so they can only present data from the indexes we decide. We already used rewrite rules to block the Settings section but we want to make sure the JSON Input parameters cannot be used maliciously.

---

<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:** [August 24, 2017, 9:02pm UTC](https://discuss.elastic.co/t/edit-a-personal-metric-by-kibana/94865/3 "2017-08-24T21:02:50Z")

</div>

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