Is there a way to search closed tickets by a user's name?
Is there a way to search closed tickets by a user's name? My boss wants to create reports this way to see if we can close any loose ends.
Forum Posts
Is there a way to report on how long each stage in a workflow took?
Management would like to know how long, on average, each stage takes to fulfill a particular request. So, what is the average time is takes to approve the request, average time to procure the item, and then average time to deliver the item.
Resolved! Cross-site scripting error in IE(Internet Explorer)
When trying to access the Number Fields present on the Dashboard in Internet Explorer I am getting an error as - "Internet Explorer has modified the page to help prevent cross-site scripting"Can you people suggest where can I look into and What can I...
Resolved! Performance Analytics - breakdown on a string field does not show results in a scorecard
Hi SNC,I need some help with PA breakdowns. Here is my case: I am trying to show a scorecard that lists different CI classes and their versions (version is a custom string field I have on the cmdb_ci table). I have created a manual breakdown which co...
Resolved! Dynamic report title for reports
Hi all, i have some reports which need dynamic title. i have the code to do it. but it is very long and not that efficient. ar a = new GlideRecord('sys_report');a.get('9d2afa8affaec3');a.title = 'Monthly Request KPI by OE - Summary for '+getMonth()...
Is there a way to stack columns in a report with multiple data sets?
I've created the report below, which shows the active Tasks and Incidents assigned to the technicians on my team. Is there a way to stack the Incidents on top of the Tasks, so that I see only one bar (with two colors) per technician? Whenever I try ...
Resolved! Wrong Color changes in the bar chart.
Hi All, I have a bar chart report woth an interactive filter. the chart has two type of data , ie 'true and false'. we have set green color for falase and red color for true. but when selecting name from the interactive filter the color of the ba...
Resolved! Can you please explain this script?
hi guys.. I have seen this script in the metric definition....could you please explain this.. here current is incident record.. // script can set answer to false to terminate processing of the metric // mi - MonitorInstance// answerif (!current.activ...
Calculating Response time in Performance analytics
hi all how can we calculate avg response time for incidents. using indicators.
Resolved! PA: Widgets do not follow Breakdown Dashboard's breakdown despite being set to do so
I have a breakdown dashboard set up to use Assignment Group as the breakdown. I've created several widgets that are set to use this breakdown, and most work fine. A few do not work and I'm not sure why. One's an OOTB time widget (Average resolution t...
Need help with PA script
I'm trying to build a script to use a breakdown. I've reached out to the community and SN before regarding this but it still isn't working as expected. The breakdown should be coming from a glide list's related field. The structure of the data goes c...
How can i add a field in the aggregation average fields in performance analytics indicator?
Hello Team, Need help to add one field in the aggregate Average filed.I need to create an indicator with average business elapsed time.However i am not getting the aggregate field "Business elapsed time" to calculate the average. If i take the facts ...
Resolved! Trying to add a new interactive filter to the top of a dashboard. Not working!
Hello, I am trying to add a interactive filter to the top of a dashboard that contains reports that pull from the asmt_metric_result table. I wanted the filter to be a choice list pulling from metric.type . This is not working! I get the error messa...
Resolved! Is it possible to create a report using multiple criteria?
Hi everyone. I need to create 1 report but the results will come from multiple search criteria e.g. search for CRs that are awaiting approval in the next 24 hours and show all CRs for the next 7 days, no matter what state they are in. Is this possibl...
Resolved! Report on Yes/No survey responses
Dear SN Community,We have a survey with a "Yes/No" question.I would like to create a report showing a pie chart with the percentage of Yes and No answers.So I would create a report on the asmt_metric_result table, filter on the records and "group by"...
