Hi,
I'm trying to create a column chart with overlay but when I set the overlay it is not showing in the chart.
Here's my query:
index="sample_data" sourcetype="management_sampledata.csv" date_month=* Status=* "Ticket Type"=* Priority=*
| eval _time = strptime(Date, "%m/%d/%y")
| eval Month = strftime(_time, "%b")
| stats count(Ticket_No) as Total by Month
| appendcols
[search index="sample_data" sourcetype="management_sampledata.csv" SLAResolution=Met
| eval _time = strptime(Date, "%m/%d/%y")
| eval Month = strftime(_time, "%b")
| stats count(Ticket_No) as On_time by Month]
| eval percentage = round((On_time/Total)*100)."%"
| table Month, On_time, Total, percentage
And here's the result:
The percentage is the overlay but it does not show anything.
What could be the problem with this?
Best regards!
Try removing the character "%" from your percentage field and let it as int/float.
Try removing the character "%" from your percentage field and let it as int/float.
It works!
I didn't realize that I just have to remove the "%" character.
Thank you! 🙂