Date (Event) for a specific event

1 Comments

  • Amy Dee

    Hi Samuel! If you would like to see the date for a specific event, you need to identify that event in a metric. Otherwise, Insights will show you all dates with events.

    To identify events with metrics, I recommend this article: Building custom metrics for the events model. It goes over the different types of field changes, the attributes associated with those changes, and some example metrics. 

    For example, if you want to find updates where a ticket is moved from the "Tier 1" group to the "Tier 2" group, the metric would look like this:

    • SELECT # Ticket Updates WHERE [Text Field] Previous Value[Group] Tier 1 AND [Text Field] New Value[Group] Tier 2 AND Ticket Status <> Deleted 

    If you put this metric in a report and slice by Date (Event), it will only show you dates for this type of update.

    I hope this helps! Happy reporting!

    1

Please sign in to leave a comment.

Powered by Zendesk