About ositaumeozulu

ositaumeozulu · ‎06-09-2022

@yuanliu wow, just wow, many thanks dear. code is working perfectly i really appreciate

ositaumeozulu · ‎06-08-2022

@yuanliu | eval ASD = strptime(ARTStartDate, "%m/%d/%Y") | where strptime('10/1/2021', "%m/%d/%Y") < ASD AND ASD < strptime('5/27/2022', "%m/%d/%Y") | stats count(ASD) as "Tx_new" by FacilityName i used the above code as directed, still no result, is there a way i can eval the where clause as a separate field so i can run a count on it

ositaumeozulu · ‎06-08-2022

hello team please i need solution to these question i have three column fields, startDate,endDate, ARTstartDate. i want to count the number of ARTstartDate that falls inbetween the two dates (i.e from startDate to endDate)

ositaumeozulu · ‎06-07-2022

Hi @gcusello Many thanks, has gotten the hang of it, for the format i was using - instead of / as in my format, thanks for all your helps, the whole codes are working now

ositaumeozulu · ‎06-07-2022

Hi @gcusello please let me upload the screenshot of the formats you asked for

ositaumeozulu · ‎06-07-2022

again i wanted to list difference in dates between two periods and i have this code | eval LPD = strptime(LastPickupDate, "%m-%d-%Y %H:%M:%S") | eval IInT = strptime(IIT, "%m-%d-%Y %H:%M:%S") | eval diff = (IInT-LPD)/86400 | stats list(diff) by FacilityName still getting blanks

ositaumeozulu · ‎06-07-2022

@gcusello code not working, i keep getting blanks , i want to add days to a date and get my answer in date format

ositaumeozulu · ‎06-03-2022

Sorry team to bother you again, i have a code that is giving me issues | eval InT = (strptime('LastPickupDate',"%m-%d-%Y %H:%M:%S")) + (('DaysOfARVRefil'+ 28)*86400) | stats list(InT) by FacilityName but the column InT is all blank, again how do i convert InT back to readable date and list them by facility names many thanks osita

ositaumeozulu · ‎06-03-2022

please i will be glad to get answer to this query | eval InT = if(((lastpickupdate + DaysOfARVRefil + 28) > IIT), "Interrupted", "Active") "lastpickupdate" and "IIT" columns are in date format, whereas "DaysOfARVRefil" is in Days(int) please how do i successfully run this query thanks osita

ositaumeozulu · ‎05-18-2022

Wow, many thanks @duncangoff3 you are awesome

ositaumeozulu · ‎05-18-2022

splunk table not giving the accurate sum of the fields in addtotals, even when i use the stats sum function, once the nos exceed 100000, it will not sum it innacurate result in the addtotals

Posts	11
Solutions	0
Karma Given	4
Karma Received	0
Member Since	‎05-18-2022

Online Status	Offline
Date Last Visited	‎06-09-2022 03:25 PM

How to count range of dates?

How to calculate dates in splunk?

How to calculate dates in my search?

How to calculate date and int columns?

Why are there sum issues in splunk table?

Re: How to count range of dates?