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!

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...