need help with months in chart

[3DGjos]

Hello, im doing a table with data from a sumarized index by month and I need help with the values of the month field I have this:

The months are misplaced.

my query is:

index=mysumarizedindex source=mysumarizedreport 
| bin _time span=1mon
|rename _time as fecha attack as "Tipo de ataque" | eval fecha=strftime(fecha, "%B-%Y") | chart count by "Tipo de ataque" fecha


thanks

[bowesmana · Accepted solution]

Columns will be sorted lexicographically, so you can do it by inverting the initial chart and then transposing it to the format you want with this

index=mysumarizedindex source=mysumarizedreport 
| bin _time span=1mon 
| rename attack as "Tipo de ataque" 
| chart count by _time "Tipo de ataque"
| eval fecha=strftime(_time, "%B-%Y")
| table fecha *
| fields - _time
| transpose 0 header_field=fecha column_name="Tipo de ataque"

Hope this helps