<form>
  <label>Police Activity</label>
  <fieldset submitButton="true">
    <input type="time" token="field1">
      <label></label>
      <default>
        <earliest>0</earliest>
        <latest></latest>
      </default>
    </input>
    <input type="text" token="Input">
      <label>Name</label>
      <default>*</default>
      <initialValue>*</initialValue>
    </input>
  </fieldset>
  <row>
    <panel>
      <title>Top Activity by Cop</title>
      <table>
        <search>
          <query>index=economy source="economy.csv" host="DESKTOP-B9KS0VG" sourcetype="csv" Job="Police" OnDuty="true" Name="$Input$"
| stats count by JobLabel,Name
| eval minutes = count * 5
| eval hours = round(minutes / 60)
| table Name,JobLabel,hours
| sort -hours</query>
          <earliest>$field1.earliest$</earliest>
          <latest>$field1.latest$</latest>
        </search>
        <option name="drilldown">none</option>
        <option name="refresh.display">progressbar</option>
      </table>
    </panel>
    <panel>
      <title>Top Activity by Rank</title>
      <chart>
        <search>
          <query>index=economy source="economy.csv" host="DESKTOP-B9KS0VG" sourcetype="csv" Job="Police" OnDuty="true"  Name="$Input$"
| stats count by JobLabel
| eval minutes = count * 5
| eval hours = round(minutes / 60)
| table JobLabel,hours
| sort -hours</query>
          <earliest>$field1.earliest$</earliest>
          <latest>$field1.latest$</latest>
        </search>
        <option name="charting.chart">pie</option>
        <option name="charting.drilldown">none</option>
        <option name="refresh.display">progressbar</option>
      </chart>
    </panel>
  </row>
  <row>
    <panel>
      <title>Average Number of Cops On</title>
      <chart>
        <search>
          <query>index=economy source="economy.csv" host="DESKTOP-B9KS0VG" sourcetype="csv" Job="Police" OnDuty="true"  Name="$Input$"
| streamstats count by Name
| eval minutes = count * 5
| eval hours = round(minutes / 60)
| eval x = round(hours,1)
| timechart span=1h avg(x) AS "Cops On Duty"</query>
          <earliest>$field1.earliest$</earliest>
          <latest>$field1.latest$</latest>
        </search>
        <option name="charting.chart">area</option>
        <option name="charting.drilldown">none</option>
        <option name="refresh.display">progressbar</option>
      </chart>
    </panel>
    <panel>
      <title>Average Number of Cops On by Rank</title>
      <chart>
        <search>
          <query>index=economy source="economy.csv" host="DESKTOP-B9KS0VG" sourcetype="csv" Job="Police" OnDuty="true"  Name="$Input$"
| streamstats count by Name
| eval minutes = count * 5
| eval hours = round(minutes / 60)
| eval x = round(hours,1)
| timechart span=1h avg(x) by JobLabel</query>
          <earliest>$field1.earliest$</earliest>
          <latest>$field1.latest$</latest>
        </search>
        <option name="charting.chart">line</option>
        <option name="charting.chart.nullValueMode">connect</option>
        <option name="charting.chart.stackMode">stacked</option>
        <option name="charting.drilldown">none</option>
        <option name="refresh.display">progressbar</option>
      </chart>
    </panel>
  </row>
</form>