Hi, I'm hoping for some help with a weird insights recipe.
For context, I have to track our company's 90 day complaint percentage, so I need to see what that number was last week, two weeks ago, etc. The same for the 7 and 30 day numbers.
My end goal is a graph that shows the #tickets marked as 'complaint' in the 7,30,and 90 days preceding a given date.
I've cobbled together 12 custom metrics that are working okay, so I have a graph with 7,30,90 numbers for the previous 4 Saturdays, but I can't go back any further without continuing to make specific metrics, and I'm paranoid that my formula isn't working.
For example, here is what I have to get the #tickets created in the 30 days preceding the Saturday 3 weeks ago (which from today should yield 8/25 - 9/23)
"select # Tickets where Date (Ticket Created) between (select round((this-1)/7))*7-44 and (select round((this-1)/7))*7-15"
Surely there is a way I could just have 3 metrics:
# tickets created in a (7,30,90) days range ending in given date.
Then I use Date (event) as the attribute, and filter for the specific dates I want to see?
Please sign in to leave a comment.