I am trying to pull only the latest monthly value for a given metric when a user is selecting multiple months in the filters. If for instance, a user selects January and February, QS is currently adding up the values for those months. In this case, I would like to display only the latest value for this measure (February’s value). I have tried the following:
- Creating a calculated field to pull the latest month–>
- Another calculated field to pull only the figure for the latest month selected: Subscriptions_v2:
I am entering an error in the second step, because QS does not allow custom aggregations to contain both aggregate “
MAX” and non-aggregated fields. I have tried making Last Month a string, but it does not work either.
Does anyone know how to pull this information?