How to get count in percentage in data table of kibana

[sushmahp]

hi,
i have data of this format.
{
"make": "LG",
"model":Model1,
"serialNo":"1801MBX11002",
"IP":"24.160.207.7",
"prevChannelName":"starPlus",
"prevTunedTime":"2018-05-28 16:24:05",
"prevEventName":"Siya ke ram",
"curChannelName":"StarMovie",
"curTunedTime":"2018-05-28 17:24:05",
"curEventName":"Race To Witch Mountain"
}

the usecase for above data is
percentage of unique users viewed a particular event for specified time.
i have to create report for above usecase in data table of kibana
so my problem is
i am not able to get unique count of users in percentage in data table.
so if anyone knows how to do it please help me out..

thanks

[christophilus (Chris Davies)]

So, you need to ask yourself a few questions:

• How is a unique user identified? Is it just the serialNo? Is it a combination of fields?

If it's a single field, you can count unique values fairly simply if it's a combination of fields, you'll need to do a scripted query as described here:

Terms aggregation | Elasticsearch Guide [8.11] | Elastic

Once you have a query that gives you a count of the distinct values, you can display an aggregate. Here's a question and answer about how to display a percentage.

Gauge with dynamic maximum value

Hi Michael, You should be able to do this using the Time Series Visual Builder. If you choose "gauge", then "panel options", you can specify "1" as your max value. Then in your gauge data settings, you can compute the dynamic ratio per table. Here's a screenshot of a similar setup: [image] Hope that helps!

One last note: it may be easier to massage your data so that it's stored in a way that makes the Kibana queries easier to write and reason about.