Hi there!
We are indexing data in ES to create dashboards using Kibana.
There is a field named Month that contains the names of the months indexed as strings to both text and keyword data types. Each month is represented by its full name, January, February and so on.
When want to order the data by month, the visualizations display the months in alphabetical order (April, February, January, etc) rather than in chronological order (January, February, March, etc).
Would it be possible to have the Month field appear chronologically rather than in alphabetical order?
Thanks!
Hi @wido Welcome to the Community
What visualization are you using on the dashboard?
Is there a timestamp field? or Just the Month in name?
Can you show us a sample of your data and what you want to show?
Absolutely!
Histograms, Heatmaps, Trend lines.
There is a timestamp field. I am using Logstash to extract the full name out of it using a ruby filter.
The sample of the data would be:
{"log_timestamp": "2022-06-06T12:01:23.478000Z", "month_full_name": "June", "hostname": "appliance_001", "os_name": "Windows 12"}
Lets sat that I want to display the amount of appliances by month in a histogram.
I tried to use the month option as the date-type histogram filter but it shows the month numbers instead of the month names like I need.
So for most things you would use the timestamp for the Histograms and Buckets and sort by that and then just add the Month Column for Display and hide the timefield etc... ...
Are you using Lens?
Show Me what you are doing with a couple screen shots...
I suspect you have not created a mapping so that would probably help to...
Or see if you can follow this.
Lens -> Table
Rows
Date Histogram -> Interval Month > Hide Column
Month
Appliance Type
Metric
Count
Sum of Sales etc
I don't have a month
I am using lens.
I am using dynamic mappings
Attaching some screenshots with test data and the visualizations I am working with.
One case using the timestamp field with a month for the minimum time interval, another sample having the month in the horizontal axis, you can see that the only available options are count by or alphabetical. The last one is sort of ridiculous combination of both.
What Version are you on?
My Bar Chart using Months..... just using the normal settings (I don't have a lot of old data but see the months)
Im in version 7.17.5.
The problem is the version. Tried the same data using v8 and I was able to get the data segregated by month with their name displayed. Just like I need.
I guess the solution is to update.
1 Like
I was able to solve this issue by updating Kibana as well as the rest of the components of the Elastic stack