Average Monthly Visitors Metric + Comparison Metrics

[PaigeQu]

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!

[Josh__Stephens]

Hi @PaigeQu - I'd suggest using the column mean function instead.  From what I understand you did, your current calculation would give you a total that only counted each unique visitor once then divided by approx count of months.  Instead, I believe you want the average number of unique visitors for each month.  Here's an example I built out in demo data.  To get the last column, I right clicked on unique visitors, selected create metric from selection, then chose mean.