Hello @Harsheena , why is the value being excluded when the filters are applied? Is the first value technically linked to the day before? I have an idea to test it out but the time granularity you would select would relate to the Datetime the missing field is related to. Try this out and let me know how it works:
Create a calculated field that will account for the first field of the day and the last, I was thinking something like this
ifelse(
addDateTime(-30, 'MI', ${STARTTIME}) <= {Date} AND {Date} <= ${ENDTIME} ,{Date}, NULL
)
Then create a filter for that calculated field (instead of using the original date field in the visual) that will take a rolling start date and end date (Beginning of yesterday and end of today) and select the exclude nulls field), then this should show the single value you are missing. I’ll include an image for the filter below
