Hello!
I am trying to create a dashboard that has two things:
1. Average Monthly Unique Visitors (which I think I created correctly: UV / Approximate Distinct Count (Months)) for 2023, 2024, & Current YTD 2025
2. For each of these metrics, I am trying to create summary change metric as well (for example, 2023 Monthly Avr UV vs. 2024 Monthly Avr UV)
The issue I am running into here is the best way to create a summary change metric that updates monthly for current YTD. So for instance, the Avr Monthly UV for 2025 so far that compares itself to 2024, but updates as months continue on in 2025.
Thank you!