Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- About sndpgiri
sndpgiri
Engager
Member since:
10-01-2021
10-06-2021
Community Statistics
| Posts | 11 |
| Solutions | 0 |
| Karma Given | 0 |
| Karma Received | 0 |
| Member Since | 10-01-2021 |
Activity Feed
- Posted Extract sub string from address on Splunk Search. 10-06-2021 06:34 PM
- Posted Linear Regression in Splunk predict by Date on Splunk Search. 10-05-2021 12:33 AM
- Posted Re: How to replace field value by string if certain condition matched on Splunk Search. 10-03-2021 02:04 AM
- Tagged Re: How to replace field value by string if certain condition matched on Splunk Search. 10-03-2021 02:04 AM
- Posted How to replace field value by string if certain condition matched on Splunk Search. 10-03-2021 01:33 AM
- Posted Re: Transform data measured in hour interval to day with some conditions. on Splunk Search. 10-02-2021 03:46 AM
- Posted Re: Transform data measured in hour interval to day with some conditions. on Splunk Search. 10-02-2021 03:41 AM
- Posted Re: Transform data measured in hour interval to day with some conditions. on Splunk Search. 10-02-2021 03:05 AM
- Posted Re: Transform data measured in hour interval to day with some conditions. on Splunk Search. 10-02-2021 02:56 AM
- Posted Transform data measured in hour interval to day with some conditions. on Splunk Search. 10-02-2021 02:20 AM
- Posted Re: Change hour interval to days and replace the value with average on Splunk Search. 10-01-2021 02:03 AM
- Posted Change hour interval to days and replace the value with average on Splunk Search. 10-01-2021 01:33 AM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 |
10-06-2021
06:34 PM
I have the following address, and I want to extract the substring. Address: 121, riverstreet, sydney, Australia. I want to extract 'sydney'. Help would be highly appreciated.
... View more
10-05-2021
12:33 AM
I want to predict Stock price and use Date as Fields to use for predicting, I am getting bad model. Is it I need to change the date to numeric? If so, how do i do it?
... View more
10-03-2021
02:04 AM
I get this error: Error in 'eval' command: Type checking failed. The '<=' operator received different types. When I use a single quote outside the value, I get No result | eval Value=if(Value<='0.02',"Good",Value)
... View more
- Tags:
- I get this
10-03-2021
01:33 AM
How do I replace a value for a field if the value is lesser than 0.02 by "Good"? Value Key date 0.02 1 1/1/2017 0.02 1 1/2/2017 0.05 1 1/3/2017 0.02 1 1/4/2017 0.02 1 1/5/2017 0.02 1 1/6/2017 Suppose the value is lesser than 0.02, I want to replace the value by string "Good" Value Key date Good 1 1/1/2017 Good 1 1/2/2017 0.05 1 1/3/2017 Good 1 1/4/2017 Good 1 1/5/2017 Good 1 1/6/2017
... View more
Labels
- Labels:
-
eval
-
fields
-
lookup
-
search job inspector
10-02-2021
03:46 AM
Actually, the date should be Date but still, I am getting all the rows instead of 1 for 24-hour interval.
... View more
10-02-2021
03:41 AM
This is the output is my command chained correctly?
... View more
10-02-2021
03:05 AM
The measurement date disappeared.
... View more
10-02-2021
02:56 AM
It worked but for the Date column, all the data appears to be 2017-01-01 00:00. The date should increment like 2017-01-01 2017-01-02 .....
... View more
10-02-2021
02:20 AM
I have data in the following format, measured in an interval of an hour. Date Restaurant id Food Code Average Order 1/1/2017 0:00 101 1 0.004 1/1/2017 1:00 101 1 0.004 1/1/2017 2:00 101 1 0.004 1/1/2017 3:00 101 1 0.004 1/1/2017 4:00 101 1 0.003 1/1/2017 5:00 101 1 0.003 1/1/2017 6:00 101 1 0.003 1/1/2017 7:00 101 1 0.003 1/1/2017 8:00 101 1 0.004 1/1/2017 9:00 101 1 0.003 1/1/2017 10:00 101 1 0.004 1/1/2017 11:00 101 1 0.004 1/1/2017 12:00 101 1 0.004 1/1/2017 13:00 101 1 0.005 1/1/2017 14:00 101 1 0.006 1/1/2017 15:00 101 1 0.006 1/1/2017 16:00 101 1 0.006 1/1/2017 17:00 101 1 0.005 1/1/2017 18:00 101 1 0.005 1/1/2017 19:00 101 1 0.005 1/1/2017 20:00 101 1 0.004 1/1/2017 21:00 101 1 0.004 1/1/2017 22:00 101 1 0.004 1/1/2017 23:00 101 1 0.004 I am trying to merge each 24-hour event into a single event and take an average of the average order. The output should be like this: Date Restaurant id Food Code Average Order 1/1/2017 101 1 0.003 I tried using a time chart, bin every time I get all 24 rows. Since I have data measured every hour which is too specific, I want to turn it to a day interval instead and take the average for the average order. Help would be highly appreciated.
... View more
10-01-2021
02:03 AM
No Luck! It will display all the 24 time interval instead of showing 1 event for those 24 rows.
... View more
10-01-2021
01:33 AM
I have a column that has events recorded in an interval of 1 hour. Example: Date Value 2010-1-1 1:00 20 2010-1-1 2:00 22 2010-1-1 3:00 21 2010-1-1 4:00 19 2010-1-1 5:00 16 ............................... ........ 2010-1-1 24:00 12 I want to group this as one row i.e display in the following format Date Value 2010-1-1 Calculate average of 24 values I want to achieve this in splunk
... View more
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
10-06-2021
10:29 PM
|
