Overlay in column chart not showing

[jvmerilla]

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!

[renjith_nair · Accepted solution]

Try removing the character "%" from your percentage field and let it as int/float.

[jvmerilla]

It works!

I didn't realize that I just have to remove the "%" character.

Thank you! 🙂