# Can we fetch date field in metric in kibana visualization. ? I tried but i failed, is there any alternative? **URL:** \ **Category:** Kibana\ **Created:** [February 29, 2016, 7:37am UTC](https://discuss.elastic.co/t/can-we-fetch-date-field-in-metric-in-kibana-visualization-i-tried-but-i-failed-is-there-any-alternative/42974 "2016-02-29T07:37:42Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Amitesh\_Gautam](https://avatars.discourse-cdn.com/v4/letter/a/2bfe46/32.png) [@Amitesh\_Gautam](https://discuss.elastic.co/u/Amitesh_Gautam)\ **Post date:** [February 29, 2016, 7:37am UTC](https://discuss.elastic.co/t/can-we-fetch-date-field-in-metric-in-kibana-visualization-i-tried-but-i-failed-is-there-any-alternative/42974/1 "2016-02-29T07:37:42Z")
I need date field and string filed in metric format. Currently Metric field it is working only for numbers and aggregation functionws ---
**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\ **Post date:** [March 1, 2016, 4:37am UTC](https://discuss.elastic.co/t/can-we-fetch-date-field-in-metric-in-kibana-visualization-i-tried-but-i-failed-is-there-any-alternative/42974/2 "2016-03-01T04:37:42Z")
What do you mean by metric format? Could you provide an example of your ES mapping and a sample document as well as a screenshot of what you're seeing in Kibana vs what you expect? ---
**Author:** ![Amitesh\_Gautam](https://avatars.discourse-cdn.com/v4/letter/a/2bfe46/32.png) [@Amitesh\_Gautam](https://discuss.elastic.co/u/Amitesh_Gautam)\ **Post date:** [March 1, 2016, 9:29am UTC](https://discuss.elastic.co/t/can-we-fetch-date-field-in-metric-in-kibana-visualization-i-tried-but-i-failed-is-there-any-alternative/42974/3 "2016-03-01T09:29:37Z")
![](https://us1.discourse-cdn.com/elastic/original/2X/c/c3697333affa10198e0e20386a565ad9e13677eb.png) ![](https://us1.discourse-cdn.com/elastic/original/2X/3/3ad757a56aa6ab44350fc5de46e2e3e27435db18.png) like this ..is there any other way for adding DATE and String field also. Currently this Metric facility is available is only for numbers. ---
**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\ **Post date:** [March 2, 2016, 4:42am UTC](https://discuss.elastic.co/t/can-we-fetch-date-field-in-metric-in-kibana-visualization-i-tried-but-i-failed-is-there-any-alternative/42974/4 "2016-03-02T04:42:08Z")
For dates, you can add them to the Metric widget, but you have to apply an aggregation, such as "min". ![](https://us1.discourse-cdn.com/elastic/original/2X/c/c12b8cdc2f5dcab0fc9f00e61441e348385ca8d1.png) For strings, you can use the Markdown widget to display arbitrary text, or the data table, if you want to display string fields, but you'd need to again apply an aggregation to select top values, for instance. ![](https://us1.discourse-cdn.com/elastic/original/2X/e/e81e346e54b96f1d84f4ea086f7931b9e3d2e8df.png) What's your use case? ---
**Author:** ![Amitesh\_Gautam](https://avatars.discourse-cdn.com/v4/letter/a/2bfe46/32.png) [@Amitesh\_Gautam](https://discuss.elastic.co/u/Amitesh_Gautam)\ **Post date:** [March 2, 2016, 6:13am UTC](https://discuss.elastic.co/t/can-we-fetch-date-field-in-metric-in-kibana-visualization-i-tried-but-i-failed-is-there-any-alternative/42974/5 "2016-03-02T06:13:02Z")
thanks . but i want this for string field also. I know Markdown Widget. but in Markdown Widget we can not fetch data from index. But in this metric we can fetch data from index. So is there any way. ---
**Author:** ![Amitesh\_Gautam](https://avatars.discourse-cdn.com/v4/letter/a/2bfe46/32.png) [@Amitesh\_Gautam](https://discuss.elastic.co/u/Amitesh_Gautam)\ **Post date:** [March 2, 2016, 6:18am UTC](https://discuss.elastic.co/t/can-we-fetch-date-field-in-metric-in-kibana-visualization-i-tried-but-i-failed-is-there-any-alternative/42974/6 "2016-03-02T06:18:38Z")
one more question. Can we remove the aggregation function name from column name(like instead of "Sum of PASS" i need only pass, but Sum function should work without showing its name. ## for exp: ![](https://us1.discourse-cdn.com/elastic/original/2X/0/07d9597adc2f4b7ed917ffba6b74215372768967.png) in table i don't want the aggregation function name. is there any way to remove the function name from the table . ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 2:00pm UTC](https://discuss.elastic.co/t/can-we-fetch-date-field-in-metric-in-kibana-visualization-i-tried-but-i-failed-is-there-any-alternative/42974/7 "2017-07-06T14:00:36Z")