Splunk Search

Top 10 stores for each state

Smiddy
Loves-to-Learn Lots

Hello folks;

Completely new to SPLUNK.

I am trying to get a table of the 10 stores for each State for the current week (as Time) but have no clue how to write it.

I would like to see average Sales for each of those 10 stores, for each State, sorted -Avg_Sales

index = Store_Index...

Fields I guess would be State, Store, Time, Avg_Sales

 

I would appreciate any ideas you may have.

Thanks so much for your time.

Smiddy

Labels (3)
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.