Monthly reporting

[ccntech]

I am trying to create a report that will show month over month reporting for web service average response time as a percentage against a threshold

sourcetype="web_logs" `web_resp_index` *

| bucket _time span=month

| stats count as total_count count(eval(resp_time>=500)) as fail_count count(eval(resp_time<500)) as success_count count(eval(resp_time=="")) as null_count by source _time

| eval success_percent=round((resp_count/total_count)*100,2)

| eval _time=strftime(_time, "%b")

| Fields - total_count fail_count success_count null_count

I now have :

source	_time	success_percent
www1	Jan	94.6
www1	Feb	93.2
www1	Mar	94.3
www2	Jan	98.5
www2	Feb	92.4
www2	Mar	84

I am looking to transpose and group so that I have 1 row per source and monthly columns

Source	Jan	Feb	Mar
www1	94.6	93.2	94.3
www2	98.5	92.4	84

[ITWhisperer]

| xyseries source _time success_percent

[ccntech]

that worked perfectly!

Wow I cannot believe the power of the community.  you answered the post within about 5 minutes.

Thank you so much.