Jack Gordon

Hello Community,

I want to basically add some colour to these results based on percentage so above 20% Green, and below red etc.

Any help would be appreciated - thanks.

JackG

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 should calculate the last update of when a custom field was changed and give a timestamp of that final change.

Is it possible that the SUM of the hours will only show the SUM hours for the month of the DATE_LAST_FIX?

Thanks!

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 ticket from the custom fields is:

"IF (D_COUNT(Updates)>1) 
THEN ((SUM(NULL VALUE TOTAL 1) + SUM(NULL VALUE TOTAL 2) + SUM(NULL VALUE TOTAL 3) + SUM(NULL VALUE TOTAL 4) + SUM(NULL VALUE TOTAL 5) + SUM(NULL VALUE TOTAL 6) + SUM(NULL VALUE TOTAL 7) + SUM(NULL VALUE TOTAL 8) + SUM(NULL VALUE TOTAL 9)  + SUM(NULL VALUE TOTAL 10)) / D_COUNT(Updates))
ELSE (SUM(NULL VALUE TOTAL 1) + SUM(NULL VALUE TOTAL 2) + SUM(NULL VALUE TOTAL 3) + SUM(NULL VALUE TOTAL 4) + SUM(NULL VALUE TOTAL 5) + SUM(NULL VALUE TOTAL 6) + SUM(NULL VALUE TOTAL 7) + SUM(NULL VALUE TOTAL 8) + SUM(NULL VALUE TOTAL 9)  + SUM(NULL VALUE TOTAL 10)) 
ENDIF"

If there is more than 1 update then the formula will divide the total hours by the number of updates per month otherwise it will double/triple/quadruple the calculated metric hours.

I have also added this calculated attribute for finding out the last time stamp update for the custom field is: 

DATE_LAST_FIX([Update - Timestamp], [Update ticket ID])

This accurately pulls the last update on my customer field "Number of active engineers" as this can be updated multiple times before the ticket is solved.

As you can see on the screenshot above, if the "Number of active engineers" per ticket is updated multiple times over a few months it will count the total hours for each month, essentially duplicating it. 

So essentially what i'd like the query to do is only count the numbers once on the last update of the custom field "Active numbers of Engineers" and then only show that number in the correct monthly column.

I tried with ChatGPT but it didn't really work to be honest. 

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 accurately based on tickets update this week and a duplicate report to filter based on last week. 

The last week should be easy as I can keep it as it is but how can I filter tickets updated this week without having to manually change it each week?

ZZ Graeme Carmichael

Still not working unfortunately, even tried different custom fields with the same result. 

ZZ 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 query as well:

ZZ 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 ideas at all please? 

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 my results down further by adding an updater tag I then get these numbers which make no sense:

The Metric path calculating i'm using is this:

Each sum path looks like this:

Any other filter I add on doesn't do this to the numbers including updater name etc only updater tag.

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 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 :)

Yes, it doesn't work and i'll probably need a calculation of some sort to make it work.