About nikita012

nikita012 · ‎07-10-2019

I have 3 fields in my table. Store_id Minutes Date 1234 40 07/06 1232 50 07/07 1234 60 07/07 1232 70 07/06 I want to display the data in following manner: Store_iD 07/06 07/07 1234 40 50 1232 70 60 Where the table has Minutes displayed based on the date for each store. Can you please provide the query.

nikita012 · ‎06-19-2019

I have 2 fields. **Store Minutes** 81145 22 81234 31 81145 38 87654 35 81234 22 81145 10 87654 13 The data should be divided in two buckets. The first bucket contains number of times when Minutes was less than 20. The other bucket contains number of times when Minutes was between 20 and 40 as shown below. I want the data to be divided in the below format. Store Bucket1 Bucket2 81145 1 2 81234 0 2 87654 1 1 Can you please provide code for the same.

nikita012 · ‎06-18-2019

Thanks it worked perfectly.

nikita012 · ‎06-18-2019

I have two fields in my data. Below is an example.The actual data contains 100 rows. Store Minutes 81145 33 81234 42 87654 120 87699 400 I want the data in the below manner. |||| shows separation of columns. 40>Minutes>30 ||||||||500>Minutes>100 81145,81234||||||||||||87654,87699 Can you please provide the code for the same?

nikita012 · ‎06-17-2019

I have 3 columns in my data. Minutes Store_ID 10 81165 20 80234 30 81165 40 80234 50 82345 I wish to generate a table in the below format. Store_ID Count Minutes 81165 2 10,30 80234 2 20,40 82345 1 50 The count corresponds to no. of appearances of the store_ID and minutes as a grouping of minutes it took. Can you please provide code for this data.

nikita012 · ‎04-11-2019

How can we configure the scripted input in splunk?

nikita012 · ‎04-11-2019

Hi, There is a excel sheet online on a particular url. I wish to input data directly from url into splunk

nikita012 · ‎04-11-2019

i have some data on a url. Is there a way to feed data directly into splunk from url rather than using excel and then feeding it.

nikita012 · ‎04-10-2019

This is the actual chart. I have used a Date field and not a _time field. When I cascade them, the date field goes away.

nikita012 · ‎04-10-2019

When I cascade two reports on a dashboard, the x-axis values automatically disappear. How can I adjust the x-axis values together with the charts. Do I need to change anything in the settings?

nikita012 · ‎04-08-2019

Following is the code:- | eval Dates=strptime(Date, "%m/%d/%Y") | sort Dates | eval Dates=strftime(Dates, "%d/%m/%Y") | eval weeknum=strftime(relative_time(strptime(Dates,"%d/%m/%Y"),"@w2"),"%Y/%V") | stats min(_time) as MinTime by weeknum | eval MinTime=strftime(MinTime,"%m/%d/%Y") | eval WeekStartDate=strftime(relative_time(strptime(MinTime,"%m/%d/%Y"),"-0w@w"),"%m/%d/%Y") This code is not giving the start date of each weeknum. 2018/39 should be 01/10/2018. It's taking the start date of the current week. How should I reslove it?

nikita012 · ‎04-05-2019

I applied the code and got year no./week no. on x-axis. Ex- 2018/39 where 2018 is the year no. and 39 is the week no. How can I get the first date of that week on x-axis. Can you please provide the code for it. Ex- 2019/01 should be 01/01/2019.

nikita012 · ‎04-05-2019

Below is my code. It starts each week from sunday. How can start each week from tuesday? Do I need to change anything in +1w@w? | eval weeknum=strftime(relative_time(strptime(Date,"%d-%b"),"+1w@w"),"%Y/%V")

nikita012 · ‎04-04-2019

I have 40 rows in my data with fields Date, Total. I want to add the values of Total for each 5 days. How can I group data 5 rows at a time?

nikita012 · ‎04-04-2019

Below is the data. Weeknum is the number of week where 01-05 are week numbers from 2019 and 40-44 are week numbers from 2018. I want to generate a chart for the same data with x-axis as the first date of each week number. Ex- 40 should be Oct 1, 2018 and 01 should be 30/12/2018. How do I do it? week Total 01 3 02 2 03 1 04 1 05 3 40 4 41 9 42 4 43 5 44 10

nikita012 · ‎04-04-2019

I applied the same code and below is the output. The code is not working for dates of previous year. I used this line in my code. eval firstOfWeek=strftime(relative_time(now(),tostring(weekno-tonumber(strftime(now(),"%V")))."w@w"),"%F ") Date weeknum firstOfWeek 06/03/2019 10 2019-03-04 06/03/2019 10 2019-03-04 14/03/2019 11 2019-03-11 23/03/2019 12 2019-03-18 24/03/2019 12 2019-03-18 01/10/2018 40 03/10/2018 40 03/10/2018 40 07/10/2018 40 08/10/2018 41 09/10/2018 41 10/10/2018 41 11/10/2018 41 11/10/2018 41 Can you specify the solution?

nikita012 · ‎04-03-2019

I have a week_number field in my data. I want to display each week_number with the date of 1st day in that week. Ex- week number Date 1 01/01/2019 2 08/01/2019 Can you please provide with the code for this

Posts	17
Solutions	0
Karma Given	0
Karma Received	0
Member Since	‎04-03-2019

Online Status	Offline
Date Last Visited	‎06-05-2020 02:04 AM

Display data in a table based on fields.

How to divide field values into groups depending o...

How do I divide data in a column based on their va...

Generate value of a field corresponding to duplica...

Can we Input data from url in splunk?

How to prevent x-axis values from disappearing on ...

How can I start each week from tuesday?

Group data 'n' rows at a time

COnvert week number to the 1st date in that week

How can I convert week number to starting date of ...