Hello i search the solution but it doesnt work any help I have "error in 'where' comance the expression is malformed. Expcected )" <form> <label>bb3</label> <description>test</description> <fieldset submitButton="false"> <input type="time" token="field1"> <label></label> <default> <earliest>-24h@h</earliest> <latest>now</latest> </default> </input> </fieldset> <row> <panel> <table> <search> <query>| inputlookup file1.csv | rename count as "file1" | append [| inputlookup file2.csv | rename count as "file2" ] | append [| inputlookup file3.csv | rename count as "file3" ] | append [| inputlookup file4.csv | rename count as "afile4" ] | append [| inputlookup file5.csv | dedup _time | rename count as "file5" ] | append [| inputlookup file6.csv | rename count as "file6" ] | where _time &gt;= relative_time(now(), $field1.earliest$) AND _time &lt; relative_time(now(), $field1.latest$) | stats values(*) as * by _time | addtotals col=t row=f label=Total labelfield=_timee</query> <earliest>$field1.earliest$</earliest> <latest>$field1.latest$</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="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> </form>   ... View more

Sorry i don't understand i have error with where in normal mode too <<form theme="dark"> <label>bb-test</label> <fieldset submitButton="false" autoRun="true"> <input type="time" token="timepicker"> <label>Range</label> <default> <earliest>-7d@h</earliest> <latest>now</latest> </default> </input> </fieldset> <row> <panel> <title>TEST</title> <table> <search> <query>| file1.csv | rename count as "file1" | append [| inputlookup file2.csv | rename count as "file2" ] | append [| inputlookup file3.csv | rename count as "file3" ] | append [| inputlookup file4.csv | rename count as "file4" ] | append [| inputlookup file5.csv | dedup _time | rename count as "file5" ] | append [| inputlookup file6.csv | rename count as "file6" ] | where _time &gt;= relative_time(now(), $timepicker.earliest$) AND _time &lt; relative_time(now(), $timepicker.latest$) | stats values(*) as * by _time | addtotals col=t row=f label=Total labelfield=_time</query> <earliest>-24h@h</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <option name="count">100</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> </form>   ... View more

I add time picker input with token timepicker but i have an error  " Error in 'where' command: The expression is malformed. Expected )." ... View more

Yes it is so. What does it mean i can't have another way to have timepicker input ... View more

How i know it is not working Because when i fill 7 days or any other date i have no result ... View more

Sorry i understand code source <dashboard theme="dark"> <label>bb-test</label> <row> <panel> <title>TEST</title> <table> <search> <query>| file1.csv | rename count as "file1" | append [| inputlookup file2.csv | rename count as "file2" ] | append [| inputlookup file3.csv | rename count as "file3" ] | append [| inputlookup file4.csv | rename count as "file4" ] | append [| inputlookup file5.csv | dedup _time | rename count as "file5" ] | append [| inputlookup file6.csv | rename count as "file6" ] | where _time &gt;= relative_time(now(), $timepicker.earliest$) AND _time &lt; relative_time(now(), $timepicker.latest$) | stats values(*) as * by _time | addtotals col=t row=f label=Total labelfield=_time</query> <earliest>-7d@h</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <option name="count">100</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> </table> </panel> </row> </dashboard>   ... View more

Is that help ? because on code source there is  confidential information <div class="control-group-container"> <div class="control-group col-1 timeinput earliest"> <label for="earliest_view56386" class="control-label" title="Earliest:">Earliest:</label> <div class="controls"> <div class="input-append"> <input type="text" size="5" value="" class="earliest_input timerangepicker-relative-earliest-time" id="earliest_view56386"><div class="btn-group timerangepicker-relative_range_unit shared-controls-syntheticselectcontrol control-default" data-cid="view56399" data-view="views/shared/controls/SyntheticSelectControl" data-name="relative_range_unit"   ... View more

I try different way but not working preset, relative, real-time...   the answer always the same "No results found. Try expanding the time range." ... View more

Thx for your help ... View more

Hello sorry to be unclear all lookup have the same model see below I need to display the items per line for each date of the range see the result file Date file1 file2 file3 file4 file5 file 04/07/2022 235 235 366 4554 56 83 05/07/2022 210 300 125 12011 15 13 06/07/2022 185 365 116 19468 26 57 07/07/2022 160 430 357 26925 67 127 08/07/2022 135 495 598 34382 108 198 Total  925 1825 1562 97340 272 478 I hope that it is clearer Thx ... View more