https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703579#M57671 <P>OK. But what is your issue here?</P><P>You have a timestamp but don't know how to render it into text with a given format? For that you use either eval or fieldformat with a strftime function.</P><P>Or you already have a string value but have some problems with putting it on a dashboard? (what problems exactly?)</P> Tue, 05 Nov 2024 08:17:45 GMT PickleRick 2024-11-05T08:17:45Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703560#M57667 <P>Hi&nbsp;</P><P>&nbsp;</P><P>How to display the day / month / time / year like the below format using simple format&nbsp;</P><P>&nbsp;</P><P>Ex- | make result&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jaibalaraman_0-1730779659064.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/33351iF9A74F8C930574D8/image-size/medium?v=v2&amp;px=400" role="button" title="jaibalaraman_0-1730779659064.png" alt="jaibalaraman_0-1730779659064.png" /></span></P><P>&nbsp;</P> Tue, 05 Nov 2024 04:08:24 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703560#M57667 jaibalaraman 2024-11-05T04:08:24Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703570#M57668 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/226870">@jaibalaraman</a>&nbsp;,</P><P>you have to use the table command and the field containing the date to display:</P><LI-CODE lang="markup">&lt;your_search&gt; | table timestamp</LI-CODE><P>There's on ly one problem I can see: having a long string like the one you shared, chars in the Single Value will be very small.</P><P>Maybe you could use more than one Single Value displaying parts of the timestamp.</P><P>Ciao.</P><P>Giuseppe</P> Tue, 05 Nov 2024 07:05:46 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703570#M57668 gcusello 2024-11-05T07:05:46Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703579#M57671 <P>OK. But what is your issue here?</P><P>You have a timestamp but don't know how to render it into text with a given format? For that you use either eval or fieldformat with a strftime function.</P><P>Or you already have a string value but have some problems with putting it on a dashboard? (what problems exactly?)</P> Tue, 05 Nov 2024 08:17:45 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703579#M57671 PickleRick 2024-11-05T08:17:45Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703630#M57673 <P>Hi All&nbsp;</P> <P>I running the below command&nbsp;<BR /><BR /></P> <LI-CODE lang="markup">| makeresults | eval refresh_time=strftime(_time, "%A,%Y-%m-%d %H:%M:%S") | table refresh_time</LI-CODE> <P><BR /><BR /></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jaibalaraman_0-1730852167574.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/33355iD68E037AFA6779F2/image-size/medium?v=v2&amp;px=400" role="button" title="jaibalaraman_0-1730852167574.png" alt="jaibalaraman_0-1730852167574.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>How to change the position like below&nbsp;</P> <P>Tuesday , 11/05/2024 NZST 22:12:39</P> <P>&nbsp;</P> <P>Thanks</P> <P>&nbsp;</P> Wed, 06 Nov 2024 15:41:08 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703630#M57673 jaibalaraman 2024-11-06T15:41:08Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703646#M57674 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/226870">@jaibalaraman</a>&nbsp;,</P><P>you have to change the time format in strftime command applying the format you like following the formats at <A href="https://docs.splunk.com/Documentation/Splunk/9.3.1/SearchReference/Commontimeformatvariables" target="_blank">https://docs.splunk.com/Documentation/Splunk/9.3.1/SearchReference/Commontimeformatvariables</A> :</P><LI-CODE lang="markup">| makeresults | eval refresh_time=strftime(_time, "%A,%d/%m/%Y %Z %H:%M:%S") | table refresh_time</LI-CODE><P>&nbsp;Ciao.</P><P>Giuseppe</P> Wed, 06 Nov 2024 07:33:01 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703646#M57674 gcusello 2024-11-06T07:33:01Z https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703659#M57675 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/226870">@jaibalaraman</a>&nbsp;,</P><P>good for you, see next time!</P><P>Ciao and happy splunking</P><P>Giuseppe</P><P>P.S.: Karma Points are appreciated by all the contributors <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Wed, 06 Nov 2024 10:17:43 GMT https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-day-month-and-time-in-single-value-tile/m-p/703659#M57675 gcusello 2024-11-06T10:17:43Z