# JSON Input - unique\_count
**URL:** https://discuss.elastic.co/t/json-input-unique-count/130422
**Category:** Kibana
**Created:** [May 3, 2018, 10:02am UTC](https://discuss.elastic.co/t/json-input-unique-count/130422 "2018-05-03T10:02:51Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@mIsabelcc](https://discuss.elastic.co/u/mIsabelcc)
#### Post date: [May 3, 2018, 10:02am UTC](https://discuss.elastic.co/t/json-input-unique-count/130422/1 "2018-05-03T10:02:51Z")
In a visualization I want to calculate in a Json Input: unique\_count \*5, with groovy
{ "script":
{ "inline": "(unique\_count.(doc['f\_agenda'].value)\*5",
"lang": "groovy" }
}
But groovy is deprecated and I can't do it. I try to do with Painless but I did'nt find the solution.
I try to do with visual buider but I need to show other graphs, and I can't do it with this visualization.
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [May 3, 2018, 4:43pm UTC](https://discuss.elastic.co/t/json-input-unique-count/130422/2 "2018-05-03T16:43:40Z")
So are you trying to get the value of the `unique_count` field multiplied by 5? If so, then just using `doc['f_agenda'].value * 5` inside a Painless scripted field or script.
If you need anything else calculated using Painless, let us know and we'll try and help.
---
### Author:  [@mIsabelcc](https://discuss.elastic.co/u/mIsabelcc)
#### Post date: [May 4, 2018, 6:41am UTC](https://discuss.elastic.co/t/json-input-unique-count/130422/3 "2018-05-04T06:41:24Z")
I want to calculate distinct values of f\_agenda and later multiply by 5.
For example:
**f\_agenda**
gomez
garcia
martinez
pepe
garcia
distinct values of f\_agenda = 4
and later 4 \* 5
Result = 20
And I want to use visualization Horizontal Bar
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [May 4, 2018, 1:35pm UTC](https://discuss.elastic.co/t/json-input-unique-count/130422/4 "2018-05-04T13:35:43Z")
Is f\_agenda an array? If so, you can do the scripted field like this:
`doc['f_agenda'].stream().distinct().collect(Collectors.toList()).size() * 5`
---
### Author:  [@mIsabelcc](https://discuss.elastic.co/u/mIsabelcc)
#### Post date: [May 7, 2018, 10:00am UTC](https://discuss.elastic.co/t/json-input-unique-count/130422/5 "2018-05-07T10:00:07Z")
f\_agenda isn't an array.
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [May 7, 2018, 10:34am UTC](https://discuss.elastic.co/t/json-input-unique-count/130422/6 "2018-05-07T10:34:34Z")
Then this can't be solved using scripted fields. A scripted field only works in the context of the document, it cannot access values from another document, so you cannot get the unique count over a time period.
What you can do is use Timelion and draw this using the expression:
`.es(metric=cardinality:f_agenda).multiply(5)`
---
### Author:  [@mIsabelcc](https://discuss.elastic.co/u/mIsabelcc)
#### Post date: [May 7, 2018, 11:33am UTC](https://discuss.elastic.co/t/json-input-unique-count/130422/7 "2018-05-07T11:33:38Z")
I can't use Timelion.
I show an example that visualization that I want to get. In this case I want to draw other bar with the unique count of f\_agenda'].value \* 5
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [May 7, 2018, 1:17pm UTC](https://discuss.elastic.co/t/json-input-unique-count/130422/8 "2018-05-07T13:17:24Z")
What you want there is not currently possible, there are 2 enhancement requests in the Kibana repo that would help you do it:
>
>
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 4, 2018, 1:17pm UTC](https://discuss.elastic.co/t/json-input-unique-count/130422/9 "2018-06-04T13:17:33Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.