elasticsearchkibanadashboard
% calculation doesn't seem correct in Kibana
I drew a Metric using TSVB by following the excellent article https://www.elastic.co/blog/how-to-display-data-as-a-percentage-in-kibana-visualizations So far so good. But when I am calculating the % manually, its no where correct.
The query which I used: For Numerator ->
eventName.keyword :UPLOAD_STAGE and payload.document.status.keyword:VALID_DOCUMENT and payload.document.type.keyword:Passport
I received a count as 55 in discover tab
For Denominator->
eventName.keyword :RETRIEVAL_STAGE
I received a count as 926 in Discover tab
So if I calculate the percentage manually, it comes as 5.9
However Kibana is showing as 68%.
I am bit confused. Is there anything wrong with my approach? Why am I having different percentage calculation result? Looking forward to help me understand the mistakes.
Solution
Lower case "and" was creating a problem. however this was fixed in 7.10 version onwards.
- How to view the different values in a geopoint to a Data table in Kibana Elasticsearch Maps
- Not able to start elastic search service
- Can I filter an array in elastic?
- Pyspark Streaming data to Elastic search index from Kafka topic , running in Jupyter notebook, causing failure
- How to move shards around in a cluster
- OData services with Elastic search
- How to query elasticsearch from spring with LocalDate
- Elasticsearch query to get values of multiple attributes
- I want to sort my elastic search aggregation data with most recent login for each user by there name
- bucket_script inside filter aggregation throws error
- Elasticsearch delete_by_query version conflict
- Case insensitive exact match in ElasticSearch
- How do I enable remote access/request in Elasticsearch 2.0?
- Fluent-bit - Splitting json log into structured fields in Elasticsearch
- Elasticsearch Devtools Queries (Regexp/Wildcard) - Not Working
- Elastic Search Analyzer at search time not working
- Elasticsearch 7.2.0: master not discovered or elected yet, an election requires at least X nodes
- Create TermsQuery with List<String> using elasticsearch java api client
- Elasticsearch: Use loop in Painless script
- How can I check nulls in Logstash pipeline in filter plugin?
- How to input a JSON file (array form) in Logstash?
- OpenTelemetry Export to Elastic Search without Elastic APM
- Can't connect to Elasticsearch with Node.Js on Kubernetes (self signed certificate in certificate chain)
- trying to pass params to elasticsearch getting null_pointer_exception
- 'Compressor detection can only be called on some xcontent bytes or compressed xcontent bytes" error when indexing a list of dictionaries
- Regexp filter in Opensearch (or Elasticsearch)
- Shards and replicas in Elasticsearch
- Search document with empty array field, on ElasticSearch
- how to rename an index in a cluster?
- Merge two indices value by a common field in elasticsearch