Resolved! Cumulative report
Hi all, Is it possible, without performance analytics, to have a cumulative trend report that displays the amount of incidents that were active in a specific date / week / month / quarter? Thanks,
Forum Posts
Over due and delayed tasks to be shown on Report based on Task table
Hi All, I want to create a report where I need to show those tasks assigned to Billing group and group them by assigned to (this part is done) but I need to also show that what all tasks are delayed and overdue and by how many days. Thanks in advan...
What is causing my Indicator from not collecting breakdown data?
Use case: Provide a list of service desk users and their % of KB articles attached for incidents worked. I created a Database view called “Knowledge Article Task User [u_knowledge_article_attached_user] to join with the sys_user table so that I can...
Sharing a report without the ability to edit
Hi all,there is a way to give a user the ability to sharing reports/dashboards with everyone without the ability to edit these reports?none of the reports role help here.I think about create new ACL for this but the problem is how to give the option ...
Resolved! how to get count of unique, active, itil-roled user accounts
How do I get a count of unique, active, itil-roled user accounts in Reporting? So far, my report is like the following: table: User Role (sys_user_has_role) filters: State is Active Role is itil User.Active is true To be expected, the User field h...
Single Score report drilldown not functioning as expected
I have a single score report in a small widget on a dashboard. The behavior I want when a user clicks on the number is to produce a list view of the report output with specific columns I've defined for all users. I have created a drilldown view on ...
How to filter a Database View
Hi All, In our instance we are having tables of change requests and change tasks. Every change request will have number of change tasks, that will get triggered according to the order defined. I am trying to create a Database View by adding these tab...
PA dashboard- Widget: Breakdown (Pivot Scorecard) - 2nd level breakdown?
Hi, Is it possible to add 2nd level breakdown to the widget type: Breakdown (Visualization: Pivot Scorecard), so the metrics like: Achieved, Open, Mttr, etc will be visible for: - Ticket Type: Incident request, Catalog Task and - for example Priori...
Cycle time reporting on Incidents
Hi everyone, I'm looking for a way to report on MTTR and Cycle Time on Incidents. Mean time to resolve seems straight forward using Average resolution time in performance analytics. However, if I want to see full cycle time, which in our world should...
Resolved! Is there a way to tell the last time a report was run
We are trying to take a look to see if there are any reports we no longer use. I did some searching on here but only found really old posts. They mentioned looking at the report_view table but I do not seem to have that table. Where can I go see t...
Why can't I select Group member [sys_user_grmember] table from 'related list conditions' on reports - need to report on users that are in more than one of a certain type of group...
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...
How to calculate tickets age for (Incidents and Service Requests)
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...
Reports to include average line
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
Resolved! Threshold bars not showing in list report fro business elapsed percentage
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...
Resolved! CMDB Archive Tables ACL's
Good morning, I'm attempting to clean up some CMDB tables and create a real CI lifecycle management process at my organization. I've created some CMDB archive rules for just "servers" and I was expecting to be able to create ACL's for the server te...
