Archive

How to get the day of week everyday in dropdown in Dashboards?

Explorer

I add the input dropdown to my dashboard which having Days of week from monday to sunday. But it needs to take the default value based on day of week of Today.

Suppose Today is Thursday, it will take Thursday as Default value. Tomorrow it should change to Friday as default value.

Is it possible to pass like that?

Thanks

Tags (1)
0 Karma

SplunkTrust
SplunkTrust

Create a base search in the dashboard to generate Date Day token

<search>
  <query>| makeresults 
| eval TodayWeekDay=strftime(now(),"%A")
| table TodayWeekDay
  </query>
  <preview>
    <set token="DefaultWeekDay">$result.TodayWeekDay$</set>
  <preview>
</search>

In the dropdown input XML code select default as $DefaultWeekDay$

<input type="dropdown" .....
   ....
   ....
   ....
   <default>$DefaultWeekDay$</default>
 </input>
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

SplunkTrust
SplunkTrust

| makeresults count=1| eval DayOfWeek=strftime(now(),"%A") | fields DayOfWeek

Similar to somesoni2 but slightly different too. should run completely on the indexers and spare the search heads.

0 Karma

SplunkTrust
SplunkTrust

This should do it

<input type="dropdown" token="dayOfWeek">
      <label>Day Of Week</label>
      <search>
        <query>| gentimes start=-7  | eval DayOfWeek=strftime(starttime,"%A") | table DayOfWeek</query>
      </search>
      <fieldForLabel>DayOfWeek</fieldForLabel>
      <fieldForValue>DayOfWeek</fieldForValue>
      <selectFirstChoice>true</selectFirstChoice>
    </input>
0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!