I have an index with some bad data in a
date field. Where
epoch_second was expected,
epoch_millisecond was indexed instead.
I added a scripted field to provide a corrected value.
I created a new Area Chart visualization.
When I try to aggregate this field for my Y axis, the field shows up in the list of valid fields.
When I try to aggregate this field for my X axis, the field does not show up.
Is there any way around this? It will be a while before I can fix this field and would like to know how to improvise in a situation like this.
My Kibana is version 6.5.3.