Dashboards & Visualizations

Average of Ack _time for each day over week

mangeshtonde
New Member

I have created a dashboard with the help of join which extract data in below format. Incoming event is mapped with outgoing event and time difference is displayed(AcK_time) 

IncEvntIDTime                        IncoingEventID            OutEvntIDTime                             OutgngEvntID       Ack_time
13 Dec 2020  14:55:52   X12356565                   13 Dec 2020 14:55:54          X12356565                2
13 Dec 2020 14:55:53    X12356567                    13 Dec 2020 14:55:54          X12356567                2

Problem statement: I want average of Ack _time for each day over week in below format.

Date               Avg of Ack_time

Monday        2

Tuesday       3

Wednesday  3

and so on.....

Thanks in advance!!

@woodcock 

Labels (1)
Tags (1)
0 Karma

woodcock
Esteemed Legend

Like this:

|makeresults
| eval _raw="IncEvntIDTime,IncoingEventID,OutEvntIDTime,OutgngEvntID,Ack_time
13 Dec 2020 14:55:52,X12356565,13 Dec 2020 14:55:54,X12356565,2
13 Dec 2020 14:55:53,X12356567,13 Dec 2020 14:55:54,X12356567,2"
| multikv forceheader=1
| fields - _raw linecount
| eval _time = strptime(IncEvntIDTime, "%d %b %Y %H:%M:%S")

| eval date_weekday = strftime(_time, "%A")
| stats avg(Ack_time) BY date_weekday
0 Karma

mangeshtonde
New Member

@woodcock - Thank you for your reply, but it didn't work.

 

 

 

 

 

 

 

0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.