I am trying to show hourly average in a Kibana Visualization. I referred to the example in this link -Hourly Average over 24 hours.
However, when I select Histogram option, I get an error saying "The index pattern mypattern* does not contain any of the following compatible field types: number". Do I need a custom script field to be added? I already have a timestamp field defined as date which I am using for time slicing.
I am using 7.5.2 of Kibana. Let me know if you need any further info.