This seems may be sort of the same issue I'm having - and reported on - over here: https://toolset.com/forums/topic/using-publication-month-as-reference-point-for-filter-in-views/
So it may be either a case that this can't be done the way I am hoping to be able to do it or I am missing something / doing something wrong.
I want to be able to use a single custom post type that I created for monthly real estate market updates using data from two different real estate boards.
One board offers less data than the other, so the Content Template needs, somehow, to refect this.
One board offers information on 6 different metrics, while the other board only offers information on 3 metrics.
Currently I have two content templates - one for each board, to allow me to display different summaries of the metrics each board provides (this prevents empty fields showing up on the posts with less data).
It occurred to me that this is not the most efficient way of tackling the issue, so I created a View for each board that includes tables for the data.
The problem I've run into is that the View seems to be using the most recent month's data as the reference point for every post, regardless of when it was published.
So November uses November's data (which, of course it should), October uses November's data, September uses November's data, and so on.
The View's content selection is set to the appropriate Custom Post Type, ordered by post date, query options (don't include current page) are deselected, limit is set to display 1 and offset is set to none, and the query filter is set to "Select posts with taxonomy: Market Update Cities the same as the current page."
I've opened up the Custom Post Types and clicked on the update button but they're still display the data from the most recent month, not the month of the actual post.