Dashboards & Visualizations

How to generate timestamps for the dataset?

gemrose
Explorer

Hi,

I am working on a POC project. I need to add timestmap command to use predict algorithm. My dataset however has the below fields.

MonthYear Year Quarter Month Subscription ID Subscription name

 

I was looking for a solution to randomly add timestamps for a period of one year. I have data from March2023 till May2023.

 

March 2023   Qtr 1 March 020b3b0c-5b0a-41a1-8cd7-90cbd63e06 SUB-PRD-EU-EDLCONTACTS
March 2023   Qtr 1 March 020b3b0c-5b0a-41a1-8cd7-90cbd63e06 SUB-PRD-EU-EDLCONTACTS

 

Labels (1)
Tags (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| eval _time=strptime("2023-03-01","%F")+(random()%(strptime("2023-06-01","%F")-strptime("2023-03-01","%F")))
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In November, the Splunk Threat Research Team had one release of new security content via the Enterprise ...

Index This | Divide 100 by half. What do you get?

November 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Stay Connected: Your Guide to December Tech Talks, Office Hours, and Webinars!

❄️ Celebrate the season with our December lineup of Community Office Hours, Tech Talks, and Webinars! ...