# Json input - calculated with derived values like unique-count **URL:** \ **Category:** Kibana\ **Created:** [February 22, 2018, 7:16pm UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116 "2018-02-22T19:16:29Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![dorj1234](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dorj1234/32/21339_2.png) [@dorj1234](https://discuss.elastic.co/u/dorj1234)\ **Post date:** [February 22, 2018, 7:16pm UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116/1 "2018-02-22T19:16:30Z")
Hi, I know how to use json input to display a simple calculation on 2 fields. For example ```auto { "script": "_value / doc['number_field1'] .value " } ``` What I don't know is how to do a calculation on an aggregated field. For example unique count. For example ```auto { "script": "_value / unique_count(doc['number_field1'] .value) " } ``` In my visialization I created a line graph showing the unique count over time. So is there a way to access that field in the visualization? Thank you! ---
**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\ **Post date:** [February 22, 2018, 9:11pm UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116/2 "2018-02-22T21:11:30Z")
You can just create a `Metric` visualization if you just want to display that unique count; ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/1/d131e378284f57f85439c094274fce20f941c17e.png) ---
**Author:** ![dorj1234](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dorj1234/32/21339_2.png) [@dorj1234](https://discuss.elastic.co/u/dorj1234)\ **Post date:** [February 22, 2018, 9:20pm UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116/3 "2018-02-22T21:20:26Z")
I wish, it's a line graph showing `unique_count(field A)` and `unique_count(field B)` over time. I just need to show a calculation of those 2 `unique_count(field A) / unique_count(field B)` over time I'm 100% sure there is a way, because it's fields in the JSON that creates the graph elements. Not familiar enough with Kibana to find out how. ---
**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\ **Post date:** [February 22, 2018, 11:29pm UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116/4 "2018-02-22T23:29:32Z")
OK, for the simple case, you can just use the unique count metric like this; ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/b/cba6cac69d2f2d4a5d81a6a8b59ecddf30295ed5.png) If you need to divide 2 unique counts over time, I think the Visual Builder could do that. In the Visual Builder unique count is `Cardinality`. It starts looking very similar like this; ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/6/862bb006853dc769b144869a00a6214575910cd0.png) I can add a second metric, and then a third that I switch to a `Calculation`. Then create a variable for each of the 2 metrics. Then use them in a simple division. Does this get you what you're looking for? ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/0/008911ec252f93b0e12b40298d08595bfb48c3c0.png) ---
**Author:** ![dorj1234](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dorj1234/32/21339_2.png) [@dorj1234](https://discuss.elastic.co/u/dorj1234)\ **Post date:** [February 23, 2018, 12:49am UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116/5 "2018-02-23T00:49:56Z")
2 cardinality fields created, and then the "calculation" option is grayed out. Maybe because I am using cardinality with string/keyword fields? ---
**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\ **Post date:** [February 23, 2018, 12:57am UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116/6 "2018-02-23T00:57:36Z")
There was an issue about that. What version are you on? ---
**Author:** ![dorj1234](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dorj1234/32/21339_2.png) [@dorj1234](https://discuss.elastic.co/u/dorj1234)\ **Post date:** [February 23, 2018, 1:21am UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116/7 "2018-02-23T01:21:56Z")
6.2.1 ---
**Author:** ![dorj1234](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dorj1234/32/21339_2.png) [@dorj1234](https://discuss.elastic.co/u/dorj1234)\ **Post date:** [February 23, 2018, 3:25am UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116/8 "2018-02-23T03:25:23Z")
I tried one more thing - took 2 metrics who's average is known to me and calculation was allowed this time (great!) but the result just gave me nothing. See screenshot In the data - the first average is 21 and the second is 15, so I was hoping to see 1.4 ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/f/ef7a350a0ff2d62c5418b066aafc8c96ccd21dfa.png) ---
**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\ **Post date:** [February 23, 2018, 2:20pm UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116/9 "2018-02-23T14:20:27Z")
Can you show a screenshot of the "Time Series" tab? By default, the Metric tab you're on will show the last value in your Time Series. So if that Time Series drops off to 0 at the end, that's what you would see in the Metric tab. But there is a way to get the overall average as well. ---
**Author:** ![dorj1234](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dorj1234/32/21339_2.png) [@dorj1234](https://discuss.elastic.co/u/dorj1234)\ **Post date:** [February 23, 2018, 4:32pm UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116/10 "2018-02-23T16:32:21Z")
Screenshot attached - when putting either field on top there is no zero value. Interesting. How do I get the overall average? ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/4/04325a7415b4025eed8b541834d91d0ce7213395.png) ---
**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\ **Post date:** [February 23, 2018, 4:36pm UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116/11 "2018-02-23T16:36:46Z")
This is kind of a long discuss thread but there are some notes about using Overall Average in it; > [@Doing Math over count of events](https://discuss.elastic.co/t/doing-math-over-count-of-events/97278/33): > > Actually if i count the numbers on Spike manually, i am getting the right value which i see in the discover tab i.e 15 for today. On the right side, it shows 0, not sure how do i actually calculate it real time. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 23, 2018, 4:36pm UTC](https://discuss.elastic.co/t/json-input-calculated-with-derived-values-like-unique-count/121116/12 "2018-03-23T16:36:58Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.