# Why i am not ablle to select my available fields in Percentiles Aggregation Field option in kibana visualization **URL:** \ **Category:** Kibana\ **Created:** [April 14, 2020, 11:27am UTC](https://discuss.elastic.co/t/why-i-am-not-ablle-to-select-my-available-fields-in-percentiles-aggregation-field-option-in-kibana-visualization/227900 "2020-04-14T11:27:23Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Pacha\_Gopi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pacha_gopi/32/45627_2.png) [@Pacha\_Gopi](https://discuss.elastic.co/u/Pacha_Gopi)\ **Post date:** [April 14, 2020, 11:27am UTC](https://discuss.elastic.co/t/why-i-am-not-ablle-to-select-my-available-fields-in-percentiles-aggregation-field-option-in-kibana-visualization/227900/1 "2020-04-14T11:27:24Z")
Hi all, I am using latest version of kibana and my task is visualize the API responce time (upstream\_responce\_time in nginx) in kibana dash board on the values of p50,p90,p99.when i select Percentiles Aggregation opition in the kibana visualization i am not getting the all avaialblle fields that i defined i am getting on two options loke mentioned below. date @timestamp number log.offset My question is why i am not able to view different fields otherthan timestamp and logset. i have upstream\_responce\_time and request time and more,i am attaching both the screenshots of available fields and visualization can anyonne help me out of this isuue. ![Screenshot from 2020-04-14 16-48-46](https://us1.discourse-cdn.com/elastic/original/3X/9/a/9a8aa7672b73eb525f4a1645c036ad771b834d81.png) ![Screenshot from 2020-04-14 16-48-46](https://us1.discourse-cdn.com/elastic/original/3X/9/a/9a8aa7672b73eb525f4a1645c036ad771b834d81.png) ![Screenshot from 2020-04-14 16-55-01](https://us1.discourse-cdn.com/elastic/original/3X/d/3/d3adbd21890c3a0571b9a7915f264fb29bc8aa7f.png) ---
**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\ **Post date:** [April 14, 2020, 11:51am UTC](https://discuss.elastic.co/t/why-i-am-not-ablle-to-select-my-available-fields-in-percentiles-aggregation-field-option-in-kibana-visualization/227900/2 "2020-04-14T11:51:37Z")
Please check the mapping of your index and make sure `upstram_response_time` is indexed as a number field. I suspect it's currently mapped as string field (and you can't calculate percentiles on a string) ---
**Author:** ![Pacha\_Gopi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pacha_gopi/32/45627_2.png) [@Pacha\_Gopi](https://discuss.elastic.co/u/Pacha_Gopi)\ **Post date:** [April 14, 2020, 12:01pm UTC](https://discuss.elastic.co/t/why-i-am-not-ablle-to-select-my-available-fields-in-percentiles-aggregation-field-option-in-kibana-visualization/227900/3 "2020-04-14T12:01:39Z")
Hi thanks for responce i will check and update you ---
**Author:** ![Pacha\_Gopi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pacha_gopi/32/45627_2.png) [@Pacha\_Gopi](https://discuss.elastic.co/u/Pacha_Gopi)\ **Post date:** [April 14, 2020, 12:14pm UTC](https://discuss.elastic.co/t/why-i-am-not-ablle-to-select-my-available-fields-in-percentiles-aggregation-field-option-in-kibana-visualization/227900/4 "2020-04-14T12:14:09Z")
Hi i am sending logs from filebeat to my logstash and i am using kv filter pugin in filter section it is working fine but when i use mutate filter pugin to convert from string to integer my logstash is not working and i am getting the error below code is my filter configuration. filter { ``` kv { field_split => " " value_split => "=" } mutate { convert => { "upstream_response_time" => "integer" } ``` } } can you guide how can i use mutate plugin along with kv plugin. Note: KV filter plugin is mandatory for my project ---
**Author:** ![Pacha\_Gopi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pacha_gopi/32/45627_2.png) [@Pacha\_Gopi](https://discuss.elastic.co/u/Pacha_Gopi)\ **Post date:** [April 14, 2020, 12:19pm UTC](https://discuss.elastic.co/t/why-i-am-not-ablle-to-select-my-available-fields-in-percentiles-aggregation-field-option-in-kibana-visualization/227900/5 "2020-04-14T12:19:40Z")
These are My logstash error logs [2020-04-14T12:18:08,215][INFO][logstash.runner] Starting Logstash {"logstash.version"=\>"7.6.2"} [2020-04-14T12:18:10,912][ERROR][logstash.agent] Failed to execute action {:action=\>LogStash::PipelineAction::Create/pipeline\_id:main, :exception=\>"LogStash::ConfigurationError", :message=\>"Expected one of [\t\r\n], "#", "{" at line 11, column 5 (byte 65) after filter {I\n \n ", :backtrace=\>["/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:41:in `compile_imperative'", "/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:49:in `compile\_graph'", "/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:11:in `block in compile_sources'", "org/jruby/RubyArray.java:2580:in `map'", "/usr/share/logstash/logstash-core/lib/logstash/compiler.rb:10:in `compile_sources'", "org/logstash/execution/AbstractPipelineExt.java:161:in `initialize'", "org/logstash/execution/JavaBasePipelineExt.java:47:in `initialize'", "/usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:27:in `initialize'", "/usr/share/logstash/logstash-core/lib/logstash/pipeline\_action/create.rb:36:in `execute'", "/usr/share/logstash/logstash-core/lib/logstash/agent.rb:326:in `block in converge\_state'"]} [2020-04-14T12:18:11,560][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600} [2020-04-14T12:18:16,335][INFO][logstash.runner] Logstash shut down. ---
**Author:** ![Pacha\_Gopi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pacha_gopi/32/45627_2.png) [@Pacha\_Gopi](https://discuss.elastic.co/u/Pacha_Gopi)\ **Post date:** [April 14, 2020, 12:35pm UTC](https://discuss.elastic.co/t/why-i-am-not-ablle-to-select-my-available-fields-in-percentiles-aggregation-field-option-in-kibana-visualization/227900/6 "2020-04-14T12:35:36Z")
Hi I converted the above upstream\_response\_time to number type from string but after this also i am facing same issue as above mentioned i am getting only logset in number section. ---
**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\ **Post date:** [April 14, 2020, 1:02pm UTC](https://discuss.elastic.co/t/why-i-am-not-ablle-to-select-my-available-fields-in-percentiles-aggregation-field-option-in-kibana-visualization/227900/7 "2020-04-14T13:02:59Z")
Did you refresh your index pattern in the management index pattern section? Otherwise Kibana won't pick up the change. Before you do that make sure that all indices matching the pattern only have a number type for this field in their mapping, no string leftovers in old indices (you either have to delete the old indicies, re-index them with the new mapping or make sure your index pattern is not matching them) ---
**Author:** ![Pacha\_Gopi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pacha_gopi/32/45627_2.png) [@Pacha\_Gopi](https://discuss.elastic.co/u/Pacha_Gopi)\ **Post date:** [April 14, 2020, 2:27pm UTC](https://discuss.elastic.co/t/why-i-am-not-ablle-to-select-my-available-fields-in-percentiles-aggregation-field-option-in-kibana-visualization/227900/8 "2020-04-14T14:27:04Z")
Thank you so much problem got solved ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 12, 2020, 2:27pm UTC](https://discuss.elastic.co/t/why-i-am-not-ablle-to-select-my-available-fields-in-percentiles-aggregation-field-option-in-kibana-visualization/227900/9 "2020-05-12T14:27:18Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.