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 ...
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...
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...
hi all how can we calculate avg response time for incidents. using indicators.
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...
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...
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 ...
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...
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...
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"...
I have several SLA Definitions to capture turnaround times with my process. I know need to link this to my PA dashboard but I'm unsure how to set up the Indicator Source. I used the SLA task table and conditioned it but it's not bring back results. D...
Hello, We have a requirement where we need to pull a report of all users how much time user spent on tickets on table like Incident, Problem. I can use OOB Metric instance for user record but how to set for Problem table ??? Please help me on thi...
Hello team, We are promoting the usage of Dashboards among the teams that are using our ServiceNow instance. Our users are having just ITIL role and not additional report roles. The issue we are having is that they may create a Dashboard and share it...
Since Dashboard was introduced on Jakarta, we had a problem on the reporting widget titles. Before it uses the Reporting Title Value now it uses the report name value. How can we force the dashboards to use the Reporting title value again? Report NAM...
Is there a way, or a plan to implement Folders for reports? We have an endless supply of reports that we see published globally and cloud the view. I'd like to be able to create a folder (with sub-folders) around these reports. Ideally the folders ...
