A query has a month time model in the time context but is only showing the last month's data. For example, using the Last Six Months time model in the time context of a query only shows the last month's data.
Reproducing the Issue
See circled below for an example query.
A month time model is not an aggregate of months. Rather it is each individual month time period. A time context does not have the functionality to aggregate the month time model so it chooses the last month's data from the month time model.
There are 2 options:
1. Move the month time model to a row or column (instead of using as a time context)
2. Create a composite query to add the months of the month time model together
There may also be an option to choose an appropriate year time model as a time context (eg. Last Year if last 12 months is required)
KBA , LOD-SF-WFA , Workforce Analytics & Planning , Problem