Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
×
Join the Conversation
Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Find Answers
- :
- About anoopk1981
anoopk1981
New Member
Member since:
10-08-2018
06-05-2020
Community Statistics
| Posts | 9 |
| Solutions | 0 |
| Karma Given | 0 |
| Karma Received | 0 |
| Member Since | 10-08-2018 |
Activity Feed
- Posted Re: How can I group last results into OTHERS? on Splunk Search. 10-12-2018 09:32 AM
- Posted Re: How can I group last results into OTHERS? on Splunk Search. 10-11-2018 12:22 PM
- Posted Re: How can I group last results into OTHERS? on Splunk Search. 10-11-2018 12:20 PM
- Posted Re: How can I group last results into OTHERS? on Splunk Search. 10-10-2018 12:08 PM
- Posted Re: How can I group last results into OTHERS? on Splunk Search. 10-10-2018 12:07 PM
- Posted Re: How can I group last results into OTHERS? on Splunk Search. 10-09-2018 04:48 PM
- Posted Re: How can I group last results into OTHERS? on Splunk Search. 10-09-2018 01:53 PM
- Posted Re: How can I group last results into OTHERS? on Splunk Search. 10-09-2018 01:44 PM
- Posted How can I group last results into OTHERS? on Splunk Search. 10-08-2018 02:46 PM
- Tagged How can I group last results into OTHERS? on Splunk Search. 10-08-2018 02:46 PM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 |
10-11-2018
12:22 PM
This is my current query..
index="marketing1" sourcetype="csv" | eventstats sum("Declared Value _USD") as total_sales |stats sum("Declared Value _USD") as sales max(total_sales) as total_sales by "Destination Country Correct Translation"|eval Percentage=sales/total_sales*100 |sort 0 - sales
... View more
10-11-2018
12:20 PM
I tried but got this result
Destination Country Correct Translation sales Percentage total_sales
Others 1855 100 1855
... View more
10-10-2018
12:07 PM
This is my main search
index = "myindex" | eventstats sum("Declared Value _USD") as total_sales |stats sum("Declared Value _USD") as sales max(total_sales) as total_sales by "Destination Country Correct Translation"|eval Percentage=sales/total_sales*100 |sort 0 - sales
So where do you suggest to put your statements?
... View more
10-09-2018
04:48 PM
top won't work. top gives me the values by the most number of occurrences . This is entirely different .
... View more
10-09-2018
01:53 PM
I tried it but in the result it shows only the first 5 rows..
"Country" "Sales" "Total Sales" "Percentage"
A 300 1855 16.5
B 250 1855 13.2
C 200 1855 10.9
D 190 1855 10.2
E 180 1855 9.7
... View more
10-08-2018
02:46 PM
Hi,
I have a search that gives me results as below
"Country" "Sales" "Total Sales" "Percentage"
A 300 1855 16.5
B 250 1855 13.2
C 200 1855 10.9
D 190 1855 10.2
E 180 1855 9.7
F 160 1855 8.6
G 155 1855 8.3
H 145 1855 7.8
I 140 1855 7.5
J 135 1855 7.2
Now I want to show only the first 5 rows and group the remaining rows into Others..something as below
"Country" "Sales" "Total Sales" "Percentage"
A 300 1855 16.5
B 250 1855 13.2
C 200 1855 10.9
D 190 1855 10.2
E 180 1855 9.7
OTHERS 735 1855 39.6
Thank You
... View more
- Tags:
- splunk-enterprise
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
06-05-2020
02:04 AM
|
