I have a health data where the fields are Population and Infected. Now for example the population of California is 38,802,500 and total infected are 50,000. Now I want to show how many are infected per 100,000 population? How can I do this in Kibana?
You can use a script field for this.
I tried using script but its not working. Can you please write a script for it as it is urgent for me. I simply want that the population is 38 million and total affected are 90k so how many will get affected when the population is 100k. To simplify mathematical equation it is like
(100,000 * Affected) / Total Population. I have two fields name Affected and Population.
I tried using script but its not working.
If you describe what you've done it'll be easier to point out what you're doing wrong. Translating the expression into Lucene's expression language is trivial so I can only assume it's something else you're having issues with.
Can you please write a script for it as it is urgent for me.
When you have an urgent problem, try to anticipate what people are going to need to be able to help you. For example, "it's not working" will almost certainly result in people having to ask for more details, adding time for you.