I have a dashboard query where I am comparing some stats between 2 different dates. I am able to use one time picker but not sure how to remove - (earliest=1587963600 latest=1588050000) and take it as a paramerter from timepicker.
source=table1 (earliest=1587963600 latest=1588050000)
| JOIN type=inner id
[ SEARCH source=table1
| rename user_id AS id ] </query>
<earliest>$currentStatus.earliest$</earliest>
<latest>$currentStatus.latest$</latest>
</search>
<query>source=table1 | rename user_id AS id | eval flag="current"
| append [ search source=table1 (earliest=1587963600 latest=1588050000)
| eval flag="before" ]
| stats AsYouLike by id </query>
I don't have accurate information, so this is about it.