topic Time filter issue when executing drilldown on a timechart dashboard in Dashboards & Visualizations

Time filter issue when executing drilldown on a timechart dashboard

aniello_cerrato — Tue, 12 Sep 2017 17:48:41 GMT

Hi,

I have a problem to execute a drilldown on a timechart dashboard.

This is the search for my source dashboard:

source="SDC_GUI_DEN_ER_V" | timechart span=1d count

I have to click on the date (format date 2017-06-30) and open a new dashboard filtered on this date:

I have tried in the following way but it isn't working. On source and destination dashboard there is a filter on the time:

      <link>
        <![CDATA[
        /app/search/eccezioni_giornaliere_dett?earliest=$click.value$&latest=$click.value$
        ]]>
      </link>
    </drilldown>

Please let me know.

Thanks,
Nello

Re: Time filter issue when executing drilldown on a timechart dashboard

niketn — Tue, 12 Sep 2017 18:20:46 GMT

@aniello_cerrato, if you want to pass on the earliest and latest time stamp for selected span from timechart, can you tried the following?

   <link>
     <![CDATA[
     /app/search/eccezioni_giornaliere_dett?earliest=$earliest$&latest=$latest$
     ]]>
   </link>

Or one without CDATA and & escaped as &

    <drilldown>
      <link target="_blank">/app/search/eccezioni_giornaliere_dett??earliest=$earliest$&amp;latest=$latest$</link>
    </drilldown>

Re: Time filter issue when executing drilldown on a timechart dashboard

DalJeanis — Tue, 12 Sep 2017 23:14:36 GMT

If the events you are seeking have anything other than the date in their _time field, you really are going to need to do some calculation on that date. The epoch value of a date is the first moment in that day. Add 86399, possibly plus .999, to get the last moment in that day.