Comparing metrics to previous period

Hi community friends 👋

I created a query to compare tickets created last month to tickets created the previous month. Here's how it looks.

 

This is great, but I'd ideally like to include something like this on our main dashboard. The problem is, the dates in these custom metrics are essentially hard coded, so if I add this to a dashboard and then filter by date range, it's not going to work. I would ideally like to have a query like this that adjusts with a date filter. So, if I look at the stats for "last week", the comparison would be to the week prior. Whereas if I look at the stats for "last month", the comparison would be to the month prior.

From all my searching and messing around, it doesn't seem like this is possible. Before I write it off completely, I wanted to check if anyone else has been able to achieve this?

Thanks so much,

Hannah

 

P.S. Here are some helpful articles I've used when it comes to comparing metrics, in case these are useful for others: