Hey @arjunpkishore5
The dashboard works but say when I select Date & Range Between 11/13/2019 9:00 and 11/13/2019 10:00 what happens is that the table will display time for 8:00 to 10:00 but it fills in all the data between 8 and 9 with 0s for the first 2 columns, and than it starts to display all the data for 9 to 10. I need it to select the exact time and display it. My guess is that the issue is coming from the way the tokens are set on the dashboard? Any idea on how to fix this issue?
<eval token="earliestTime">if(isstr(earliest), relative_time(now(),earliest), earliest)</eval>
<eval token="latestTime">if(isstr(latest), relative_time(now(),latest), latest)</eval>
<eval token="earliestTime1">relative_time(earliestTime,"-7d")</eval>
<eval token="latestTime1">relative_time(latestTime,"-7d")</eval>
<eval token="earliestTime2">relative_time(earliestTime,"-14d")</eval>
<eval token="latestTime2">relative_time(latestTime,"-14d")</eval>
<eval token="earliestTime3">relative_time(earliestTime,"-21d")</eval>
<eval token="latestTime3">relative_time(latestTime,"-21d")</eval>
<eval token="earliestTime4">relative_time(earliestTime,"-28d")</eval>
<eval token="latestTime4">relative_time(latestTime,"-28d")</eval>
</change>
... View more