We have realized that while doing data analysis via the Pivot Tables there seems to be an error while using the time dimension.
When selecting Last 3 months, we get the following table:
But when selecting only January (via Last month) we get the following table:
It seems that these numbers come from this:
So we believe that the last month option is not properly selecting the whole month. Maybe it is because it is based on checking if Monday belongs to that month?
Unfortunately I cannot reproduce this in the test environment as there is no data available for January.
Thanks for your time,