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!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...