I didn't use all of the parameters I created, but I did setup a "silent" search on the dashboard to generate them.
<search id="silentsearchgettimes">
<query>| makeresults count=1| eval weeknumber=strftime(_time,"%U"), mdaynumber=strftime(_time,"%d") , absdaynumber=strftime(_time,"%j"), wdaynumber=strftime(_time,"%w"), monthnumber=strftime(_time,"%m"), dayhour=strftime(_time,"%w%H"),hour=strftime(_time,"%H"),combined=strftime(_time,"%U%w%H")</query>
<earliest>-10m</earliest>
<latest>now</latest>
<finalized>
<condition match=" 'job.resultCount' != 0">
<set token="monthnumber">$result.monthnumber$</set>
<set token="weeknumber">$result.weeknumber$</set>
<set token="absdaynumber">$result.absdaynumber$</set>
<set token="wdaynumber">$result.wdaynumber$</set>
<set token="mdaynumber">$result.mdaynumber$</set>
<set token="dayhour">$result.dayhour$</set>
<set token="hour">$result.hour$</set>
<set token="combined">$result.combined$</set>
</condition>
</finalized>
</search>
And then in individual searches called them. The one below uses "combined" which combines current week#,weekday# and hour.. So the output right now for combined would be 17413..This keeps last years week to date panel in line with a current search of live data using earliest=@w0 latest=now. At least within an hour.
index="someindex " sourcetype="order_csv" source="order_history_updDateFormat.csv" host="somehost" earliest=-1y@w0 latest=-1y+7d | fields revenue
|eval combined=strftime(_time,"%U%w%H")
|where combined<=$combined$
|stats sum(revenue) AS Revenue
... View more