https://community.splunk.com/t5/Splunk-Search/Top-10-stores-for-each-state/m-p/528443#M149222 <P>Hello folks;</P><P>Completely new to SPLUNK.</P><P>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.</P><P>I would like to see average Sales for each of those 10 stores, for each State, sorted -Avg_Sales</P><P>index = Store_Index...</P><P>Fields I guess would be State, Store, Time, Avg_Sales</P><P>&nbsp;</P><P>I would appreciate any ideas you may have.</P><P>Thanks so much for your time.</P><P>Smiddy</P> Sun, 08 Nov 2020 15:39:51 GMT Smiddy 2020-11-08T15:39:51Z https://community.splunk.com/t5/Splunk-Search/Top-10-stores-for-each-state/m-p/528443#M149222 <P>Hello folks;</P><P>Completely new to SPLUNK.</P><P>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.</P><P>I would like to see average Sales for each of those 10 stores, for each State, sorted -Avg_Sales</P><P>index = Store_Index...</P><P>Fields I guess would be State, Store, Time, Avg_Sales</P><P>&nbsp;</P><P>I would appreciate any ideas you may have.</P><P>Thanks so much for your time.</P><P>Smiddy</P> Sun, 08 Nov 2020 15:39:51 GMT https://community.splunk.com/t5/Splunk-Search/Top-10-stores-for-each-state/m-p/528443#M149222 Smiddy 2020-11-08T15:39:51Z