Dashboards & Visualizations

How to group fields and convert time to readable format?

_Raj
Engager

My task is like I need to group by two fields i.e  eventid and dest  make it happened at  firsttime and lasttime   

eventid      dest                                    count                firsttime                                     lasttime 

256             drdydyf.google.com    56                  2022-09-28T19:21:10             2022-09-28T19:21:34  

249               bigdaddy.com         78                         2022-09-28T19:22:10              2022-09-28T19:22:20

Labels (1)
Tags (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

Is those the current results or the desired results?  Is the former then what are the desired results?  What do you mean by "readable"?  ISO8601 is perfectly readable, IMO.  What format do you want.

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Developer Spotlight with Brett Adams

In our third Spotlight feature, we're excited to shine a light on Brett—a Splunk consultant, innovative ...

Index This | What can you do to make 55,555 equal 500?

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

Say goodbye to manually analyzing phishing and malware threats with Splunk Attack ...

In today’s evolving threat landscape, we understand you’re constantly bombarded with phishing and malware ...