How to filter by date/week a custom field is updated?
I have a bunch of tickets i'd like to report on but only for specifically when a custom field is updated this week.
I can't report based on ticket updated this week as many departments comment on the same ticket.
I also cant report on ticket created/solved date as these can be weeks before/after the specific field is updated.
So essentially i'd imagine there is some sort of formula that could say IF *Custom field* is updated this week then then show ticket ID?
Any help will be appreciated and if the solution works feel free to leave your Tip-jar/Paypal and i'll send you a Tip :)
- Use the Support Updates History dataset to create your report
- From the Calculation menu on the right hand side, create a new Standard Calculated Attribute
Set up your report output, for example:
- Filter your new attribute to exclude NULL values
Hope you are well! I'm pretty certain this can be done with little effort by using mostly default attributes and a custom metric/attribute similar to the one mention in Explore recipe: Tracking ticket assigns across groups.
Essentially you will need to:
- Use the Updates History dataset
- Use the Time Attribute "Update - time" not "Ticket updated - time"
- Work with the recipe I linked but use the Field name of your ticket field instead of groups.
Let me run you through what I did on my test account here at my fictional T-Shirt retailer:
I've created a metric that looks like the below: (using the exact field name and the tags associated to each field option as the "New Value")
I made sure with this that I track if the first time the field is changed. I guess you could make this formula much more complex if needed to incorporate any type of change from one to the other value.
I then added the metric to my query and use the "Update - time" attribute (to showcase I used the exact timestamp) and limited my query to only show tickets that had an update to this field within the wanted timeframe.
I've highlighted a specific example ticket there which I can show you below to ensure the metric only counts the updates made during that time and the timestamp shows correct (not any other update timestamp after or before the change):
I believe this is the best approach here. You could potentially create an attribute rather than a metric to filter, but if you use the metric you can just use a metric filter to remove all 0's
Hope this helps!
Please sign in to leave a comment.