Jack Gordon
-
Total activity39
-
Last activity
-
Member since
-
Following0 users
-
Followed by0 users
-
Votes4
-
Subscriptions14
Activity overview
Latest activity by Jack Gordon-
Jack Gordon created a post,
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...
-
Jack Gordon created a post,
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...
-
Jack Gordon created a post,
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...
-
Jack Gordon commented,
Graeme Carmichael Still not working unfortunately, even tried different custom fields with the same result.
-
Jack Gordon commented,
Graeme Carmichael Thanks for the response. So the Date Diff looks like its capturing the ticket ID's but for all ticket fields not the ones we specifically told it too.. I added this Date diff qu...
-
Jack Gordon commented,
Graeme Carmichael Doesn't seem to be working for some reason :s Field I'm reporting on: Calculated attribute: Results are not pulling any ticket ID's: Even when excluding NULL values: Any ide...
-
Jack Gordon created a post,
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...
-
Jack Gordon created a post,
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...
-
Jack Gordon commented,
Yes, it doesn't work and i'll probably need a calculation of some sort to make it work.
-
Jack Gordon created a post,
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 ...