Jack Gordon
-
Activité totale39
-
Dernière activité
-
Membre depuis
-
Abonné à0 utilisateur
-
Abonnés0 utilisateur
-
Votes4
-
Abonnements14
Publications
Activité récente par Jack Gordon-
How to calculate a SUM metric based off DATE_LAST_FIX of a customer field?
Hello Community, I'm stuck on a problem, if you look at the below screenshot: I have a calculated attribute that has the formula: DATE_LAST_FIX([Update - Timestamp], [Update ticket ID]) This s...
-
How can I get this formula to only calculate on the last custom field update timestamp?
Hello Community, I'm stuck on writing a formula to stop my metric double counting the last update time stamp for a custom field that I have. The metric I have to calculate the hours worked per tic...
-
How can I filter a DATE_DIFF based on this week / last week rather than "nb_of_days"?
Hello Community I'm trying to build an explore query that filters based on this week and last week for a specific field being updated. Is there a way I change this query to filter more accurate...
-
Bug when applying updater tag to query?
Hello Team, I've found a strange bug when I try to filter my results down further, the SUM on the end column is calculating the numbers fine with the current query: However when I try to filter...
-
How to filter by date/week a custom field is updated?
Hello Community, 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 depa...
-
How can I create totals for standard calculated attributes?
Hello Team I have some standard calculated attributes like below: However I need to calculate total of the hours worked rows to summarise all the hours worked by the engineers on each ticket. So ...
-
Is it possible to hide Ticket forms by user tags or groups?
Hey guys, Our company has a number of different forms that different departments use, however for our department we only use a small amount of them. Is it possible to hide the ones I don't want age...
-
Applying User tags from a ticket Macro
Hello Community, Is it possible to add User tags when a macro is used? We give a product to a customer by the way of postal delivery rather than physical visit and we filter our queries based o...
-
Unable to report on 2 separate tags with custom metrics..
Hello Team, I have a custom field 2 separate answers, "-Yes-" and "-No-": I'd like top create a Line chart or a stacked chart to report on both tags for each week of the year but when I create a c...
-
Stacked chart or comparing % difference between 2 tickets tags in the same week?
Hello ZD Community, I hope you are well. I'm trying to create a stacked chart between 2 ticket tags that we record each week, a simple Yes/No Tag. I either want a way to show a stacked chart ...