Hi, I need to report on users that are in more than one group from a list of groups. For example, any users that are in 'service desk' and also in another itil groups. I was going to report on the user table and then in 'Related list conditions' sel...
I need to be able to measure the percentages of tickets that are older than 30 days. I have build an SLA that will count days open on an ticket named SLA 3-17 Ticket Ageing and it will breach when it is more than 30 days. I am measuring the SLA as a...
hi all, is there a way to include average line on normal bar graph. eg. That should include the average also. I have a feeling that it is possible by PA but as i don't have experience there, i need a good guide to achieve the goal here thanks,Jake
Hi, I'm creating a list report based on a database view. The database view consists of the task_sla table to which I left join the incident, sc_req_item and problem tables. Basically creating a view with these records and their SLAs. When viewing the...
Hi! I'm having problems with a heatmap widget not showing any data, despite the data being listed in the indicator scorecard for both breakdowns. So what I have is a database view that I use in the indicator source. This is a joined view with the t...
I have created a simple custom interactive filter based on the incident table. This will filter the assignment group in the pie chart to Database if i click the Database-button. Even though I have set the pie chart to 'Follow interactive filter' it'...
Just to start we are not using Performance Analytics. Is there a way to get a report that show incidents created in the last 48 hours? I noticed that If I do created on then click the drop drown there is an option for last 2 hour.
Is it possible to create a list/report that lists all incidents, changes, problems, etc. for a single configuration item?Thanks,Mike G
Hi all! I've been tasked with creating a report to show the average time spent to fulfill a request. I'm rather new to all of this, and am not sure if I'm hitting the mark with the report I've put together or not. Source Type: Table Table: Request ...
The field that I am trying to add is "Has Breached" from Task_Sla table.
Hi friends, I am not a reporting expert. Need help in writing a schedule job for a report to send an email on last friday of every month. I went to report and then click on schedule, under Run selected monthly and it shows day of the month. Please ...
Hello, I am working on setting up PA for our company, and I noticed that the open incidents indicator source filters incidents based on if resolved=empty. None of our cancelled incidents have a resolved date, so they are also appearing in the open in...
HI, I've seen this question posted a few times but none seem to have gotten an answer because the OP never got back to their question. I have created a report based on the type Trend, where the x-axis are months. It shows amount of high priority tick...
Hi Experts, I have reports which tell me how many incidents were created and resolved each month but I also want to have what is the backlog for each month , i.e. on given month how many incidents / requests were in active state. Is it possi...
Hi everyone, I would like to now how can I sort a report that has been grouped by. I want to sort it in descending order. I suppose that I need to use pivot tables, but I don't know how. Thanks in advance