Splunk Search

How to create double aggregation on timechart?

mxh7777
Path Finder

Hi,

I got a table data with 3 fields (Time, Method, Return)

Time Method Return
28/10/2022 Method 1 KO
28/10/2022 Method 2 KO
28/10/2022 Method 1 OK
28/10/2022 Method 1 OK
28/10/2022 Method 1 OK
28/10/2022 Method 1 OK
... ... ...
29/10/2022 Method 2 OK
29/10/2022 Method 2 OK
29/10/2022 Method 2 OK
29/10/2022 Method 2 OK
29/10/2022 Method 2 OK
29/10/2022 Method 2 OK
29/10/2022 Method 2 OK

 

I'd like to make a timechart with double agregation (one per Method, then one per Return) to get this kind of chart

mxh7777_0-1667566270394.png

The only thing I can do for the moment is this chart with this request

 

 

| timechart count(eval(Return="KO")) as KO count(eval(Return="OK")) as OK by Method

 

 

mxh7777_1-1667566328983.png

Do you know how I can get the first timechart ?

 

Thanks

 

Labels (2)
0 Karma
Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...