Reporting

Can this Report be improved - and the Month shown on the x axis

Skins
Path Finder

At this time if i run this over 4 months the x axis shows Month, day - all i want to see is month.

And can this search be improved ?

gratzi

index=response source=responsetimes 
| table _time, ACTION_TIME
| sort - ACTION_TIME
| convert rmcomma(ACTION_TIME)
| eval ACTION_TIME = (ACTION_TIME/1000)
| timechart avg(ACTION_TIME) as "Average" span=1d
| append [search index=response source=responsetimes
| table _time, ACTION_TIME 
| sort - ACTION_TIME
| convert rmcomma(ACTION_TIME)
| eval ACTION_TIME = (ACTION_TIME/1000)
| eventstats p5(ACTION_TIME) as top5perc
| where ACTION_TIME < top5perc 
| timechart avg(ACTION_TIME) as "Top 5%" span=1d]
| append [search index=response source=responsetimes
| table _time, ACTION_TIME 
| sort - ACTION_TIME
| convert rmcomma(ACTION_TIME)
| eval ACTION_TIME = (ACTION_TIME/1000)
| eventstats p95(ACTION_TIME) as bottom5perc
| where ACTION_TIME > bottom5perc 
| timechart avg(ACTION_TIME) as "Bottom 5%" span=1d]
| timechart first(*) as *
Tags (1)
0 Karma
Get Updates on the Splunk Community!

Maximize the Value from Microsoft Defender with Splunk

<P style=" text-align: center; "><span class="lia-inline-image-display-wrapper lia-image-align-center" ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

<FONT size="5"><FONT size="5" color="#FF00FF">Get the latest news and updates from the Splunk Community ...