Splunk Search

_time not showing up in data model

jeremiahc4
Builder

I indexed some csv data which has a field called Open Time which winds up being selected as the _time and looks fine via a regular search. I can do timechart based on the data in search.

It breaks down when I throw it into a data model though. _time is not selectable as an auto-extracted attribute in the data model definition. I assume I am missing something. This is preventing me from doing timecharts within pivot.

Tags (3)
1 Solution

sowings
Splunk Employee
Splunk Employee

It sounds like you started from a "root search". Try "root event" instead. In the latter case, _time should appear as one of the auto-extracted fields. I had the same issue.

View solution in original post

sowings
Splunk Employee
Splunk Employee

It sounds like you started from a "root search". Try "root event" instead. In the latter case, _time should appear as one of the auto-extracted fields. I had the same issue.

jeremiahc4
Builder

that was it, must have missed that in the instructions somewhere and couldn't find an existing question that answered it

0 Karma
Get Updates on the Splunk Community!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...