About nu_learner

nu_learner · ‎03-09-2023

Hello - I need to calculate the average duration between two status types for a user type in a location in a region. I have attached the sample data. For example, I need to calculate the average duration a given user type remains in "inactive" status. These user types are segregated into different locations in different regions. Sample data: The result is want is like this (time is in seconds): aaa bbb ccc Day 1 30 40 10 Day 2 10 20 30 Day 3 20 10 10 and so on I would appreciate any help.

nu_learner · ‎01-17-2023

Another example that helped me: https://community.splunk.com/t5/Splunk-Search/top10-for-each-span-in-a-time-chart/m-p/456597

nu_learner · ‎01-17-2023

Thank you @cwinkler109 - your answer helped me as well!

nu_learner · ‎01-13-2023

Hello, I am new to splunk. I need to get the top 5 products sold for each day, for the last 7 days. The products could be different each day, as shown in the example below. Day (X-Axis) Top 5 Products (Y-Axis) 1 2 3 4 5 1 P1 PA P4 AC ZX 2 P2 PB P5 AR P1 3 P3 PC PA P5 AC 4 P4 P1 P1 P4 AR 5 P5 PD AB AX AB Is there a way to get it done? I tired the following but it gives me the same 5 products for all days and puts everything else in "OTHER" bucket: [my search] | table _time, Product | timechart count(Product) byProduct WHERE max in top5

Posts	4
Solutions	0
Karma Given	0
Karma Received	1
Member Since	‎01-13-2023

Online Status	Offline
Date Last Visited	‎03-09-2023 11:59 AM

Duration between two events by day based on three ...

How to get top 5 products for each day for 7 days?

Duration between two events by day based on three ...

Re: How to get top 5 products for each day for 7 d...

Re: top10 for each span in a time chart

How to get top 5 products for each day for 7 days?