topic Re: Unable to run query containing gentimes from dashboard in All Apps and Add-ons

Unable to run query containing gentimes from dashboard

msashish — Wed, 30 Sep 2020 04:07:24 GMT

Hi,

I am using below to generate a date information which I shall later use:

This works fine on search but does not work from within dashboard query (Within dashboard query I replaced > & < with corresponding html tags).

When run from dashboard query I keep getting "Could not create search" (appears it has not been able to resolve startDate and endDate)

Is there any way I can save above & refer in dashboard (for joining to other queries) ?

Re: Unable to run query containing gentimes from dashboard

msashish — Mon, 17 Feb 2020 08:34:55 GMT

Looks like map command does not work with single $. I tried $$ for my variables and it worked. Testing further.

Re: Unable to run query containing gentimes from dashboard

to4kawa — Sat, 29 Feb 2020 00:54:25 GMT

<dashboard>
  <label>AsOfDate</label>
  <row>
    <panel>
      <table>
        <search>
          <query>| makeresults count=2
| streamstats count
| eval _time=if(count=1,relative_time(_time,"-4y@y"),relative_time(_time,"+2w@w"))
| makecontinuous span=1d _time
| eval AsOfDate=strftime(_time,"%Y-%m-%d")
| sort AsOfDate
| eval Weekday=strftime(_time, "%A")
| eval flag=case(_time > now(),"future",1==1,"past")
| table AsOfDate, Weekday , flag</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
      </table>
    </panel>
  </row>
</dashboard>