<form version="1.1" theme="light">
<label> Report </label>
<search id="Night">
<query>| inputlookup handover_timeline.csv
| dedup Shift Date
| search Shift="Night"
| appendcols [| maker...
See more...
<form version="1.1" theme="light">
<label> Report </label>
<search id="Night">
<query>| inputlookup handover_timeline.csv
| dedup Shift Date
| search Shift="Night"
| appendcols [| makeresults count=24
| streamstats count as Timeline
| eval Timeline=if(Timeline<10, "0".Timeline.":00", Timeline.":00")
| table Timeline]
| streamstats first(Date) as Date, first(Shift) as Shift
| tail 6
| sort Timeline
| append [| inputlookup handover_timeline.csv
| dedup Shift Date
| search Shift="Night"
| appendcols [| makeresults count=24
| streamstats count as Timeline
| eval Timeline=if(Timeline<10, "0".Timeline.":00", Timeline.":00")
| table Timeline]
| streamstats first(Date) as Date, first(Shift) as Shift
| head 6 ]
| fields Date Shift Timeline "Hourly details of shift"</query>
<done>
<set token="SID1">$job.sid$</set>
</done>
</search>
<search id="Day">
<query>| inputlookup handover_timeline.csv
| dedup Shift Date
| search Shift=Day
| appendcols
[| makeresults count=24
| streamstats count as Timeline
| eval Timeline=if(Timeline<10, "0".Timeline.":00", Timeline.":00")
| table Timeline]
| streamstats first(Date) as Date, first(Shift) as Shift
| streamstats count as row_number
| eventstats max(row_number) as total_rows
| where row_number > 6 AND row_number <= total_rows - 6
| fields - row_number, total_rows</query>
<done>
<set token="SID2">$job.sid$</set>
</done>
</search>
<search>
<query>
| makeresults
| eval token="$date_tok$"
| eval earliest=if(token="today", relative_time(now(), "@d"), strptime(token, "%d/%m/%Y"))
| eval latest=if(token="today", now(), earliest + 86400)
| table earliest, latest
</query>
<finalized>
<set token="earliest_tok">$result.earliest$</set>
<set token="latest_tok">$result.latest$</set>
</finalized>
<earliest>-7d@d</earliest>
<latest>now</latest>
<refresh>300</refresh>
<refreshType>delay</refreshType>
</search>
<fieldset submitButton="false">
<input type="dropdown" token="date_tok" searchWhenChanged="true">
<label>Date:</label>
<fieldForLabel>Date</fieldForLabel>
<fieldForValue>Date</fieldForValue>
<search>
<query>
| makeresults
| timechart span=1d count
| sort - _time
| eval Date=strftime(_time, "%d/%m/%Y"), earliest=relative_time(_time, "@d")
| table Date, earliest
| tail 7
| sort - earliest
</query>
<earliest>-7d@h</earliest>
<latest>now</latest>
</search>
<choice value="today">Today</choice>
<initialValue>today</initialValue>
<default>today</default>
</input>
<input type="dropdown" token="shift_tok" searchWhenChanged="true">
<label>Shift:</label>
<choice value="Day">Day</choice>
<choice value="Night">Night</choice>
<default>Day</default>
<initialValue>Day</initialValue>
<change>
<condition match="$value$ == 'Day'">
<set token="selected_shift">$SID1$</set>
</condition>
<condition match="$value$ == 'Night'">
<set token="selected_shift">$SID2$</set>
</condition>
</change>
</input>
</fieldset>
<row>
<panel>
<html>
NOTES: The data shown corresponds to the start of the shift, which is 6:45 AM for the Day shift and 6:45 PM for the Night shift.
</html>
</panel>
</row>
<row>
<panel id="flf">
<title>FLF</title>
<single>
<search>
<query>| inputlookup daily_ticket_count.csv
| eval today = strftime(now(), "%d/%m/%Y")
| eval Date = if(Date == today, "today", Date)
| search Shift="$shift_tok$" Date="$date_tok$"
| where isnotnull(FLF_perc)
| head 1
| fields FLF_perc</query>
<earliest>$earliest_tok$</earliest>
<latest>$latest_tok$</latest>
</search>
<option name="drilldown">none</option>
<option name="height">75</option>
<option name="numberPrecision">0.00</option>
<option name="rangeColors">["0xd93f3c","0x65a637"]</option>
<option name="rangeValues">[80]</option>
<option name="refresh.display">none</option>
<option name="unit">%</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
</single>
</panel>
<panel>
<title>Ticket Count</title>
<table>
<search>
<query>| inputlookup daily_ticket_count.csv
| eval today = strftime(now(), "%d/%m/%Y")
| eval Date = if(Date == today, "today", Date)
| search Shift="$shift_tok$" Date="$date_tok$" type IN ("Request", "Incident")
| fields - FLF_perc
| head 2</query>
<earliest>$earliest_tok$</earliest>
<latest>$latest_tok$</latest>
</search>
<option name="drilldown">none</option>
<option name="refresh.display">progressbar</option>
</table>
</panel>
</row>
<row>
<panel>
<title>Timeline</title>
<table>
<title>$shift_tok$</title>
<search>
<query>| loadjob $selected_shift$ | table Date Shift Timeline "Hourly details of shift"</query>
</search>
<option name="count">13</option>
<option name="drilldown">none</option>
</table>
</panel>
</row>
</form> Now getting this message for the Timeline panel. Search is waiting for input. Full XML above, if someone can spot any errors.