Currently, I have dashboard which has time input as "Today" which lists the total count of Payments
index=myindex "paymentmodule" | stats count as Payments
I can add another "Time Input -2" with same search which I used above for "Time Input-1"to existing dashboard but I don't know how to make the "Time input -2" dynamic so that I can compare the total counts for any weekday with current day.
For e.g. Total count for current week Wednesday v/s Total count for last week Wednesday
I could not find any option to make Time Range -2 dynamic so that I need not to go and manually change values in time picker
@harishnpandey, you can do this from the search done event handler it extracted the Job's earliest and latest time and calculates adjusted time as 7 days prior. However, this will work only if single day is selected from the first time picker.
If you are on Splunk 6.5, you should also explore the timewrap function for overlaying weekly data. For version prior to 6.5 check out appendcols command to have single query plot current day and last week same day data in a single chart.