Issue with Filter

Hi everyone, 

I am facing an issue with a filter. So I am filtering this cluster column chart with 2 filters. 

First filter Current year offset, where I use value 0 meaning that only dates in the current year shall be used. 

The second filter Past/Present, where I mark in my calendar Lookup all the dates from Previous months as past. Dates from the current month are marked as future.  

When I go in query and apply filters in the above columns I get 244 values which are all the dates from January until the end of August. 

When I apply this filters in my graph I only get 182 values and this is because of the Past/Present filter. 

Please check video below. 

https://www.loom.com/share/f7d55f936dd045cfbfe45bb9fd7a4a7f?sid=1917e319-52d3-4941-9e1c-37e0fc9cecf3

Any ideas why this discrepancy?

Thank you very much for your time 🙂