Why am I seeing less records when I use “BETWEEN” as my filter option on my dashboard, compared to my report?
|Knowledge Article Number||000212921|
|Description||Using “BETWEEN” in dashboard filter returns less records as compared to the source report.
|Resolution||This is an expected behavior. This filter option uses the logic “>= AND <”, thus will not include records that exactly matches the maximum value set on it (see image below for reference - The top one is the dashboard filter and bottom one is report):
This means if my report uses created date on certain object's records, then with the maximum date value as 2/1/2015 report pulls up the records created on 2/1/2015 along with the other dates as mention in the filter
Whereas the dashboard filter will filter out the records created on 2/1/2015