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!

Unleash Unified Security and Observability with Splunk Cloud Platform

     Now Available on Microsoft AzureOn Demand Now Step boldly into the AI revolution with enhanced security ...

Enterprise Security Content Update (ESCU) | New Releases

In March, the Splunk Threat Research Team had 2 releases of security content via the Enterprise Security ...

Join the Splunk Developer Program Hackathon: Splunk Build-a-thon!

The Splunk Developer Program is launching in beta, and we’re celebrating with an exciting hackathon! This is ...