Not sure which board to post this one, but I came across a strange potential 'bug' and wondered if anyone else has seen it and, if so, if anyone knows how to avoid it or flag when it occurs to the end user.
The bug: When selecting three months in my year/month filter the data was filtered to only two months. The selection in the bar showed all three months as if they were selected and the data was filtered for those three months. Only because I know what the number should be did I know it was not filtering correctly. I removed the filter and tried to select again, this time making each click slower, and the number came out correct. I was able to replicate the bug (as in selection shows three months, data only shows two months) consistently when clicking fast. I tried again later in the day and was unable to replicate the bug. The only difference I can think off, between the time where I could replicate the bug and when I could not, is that our daily refresh tasks were running when the bug occurred.
As we are trying to increase our staff's trust in data this is not a great thing to have happen. If anyone have experience dealing with this bug and have ideas on how to either solve it or give warning when it happens, it will be greatly appreciated.