Hi everyone. I need to build a dashboard with some sort of visual showing how many changes were completed ahead of schedule. So where the "Actual End Date" was before the "Planned End Date". End goal is to get a percentage or count per month. I can...
Dear Community, I want to create a data dump as a one time report for one key service catalogue item. The report would need to contain our sc_req_item values, sc_task values, sysapprover_approver values in one report for business analysis by another...
We have created one report on "task_sla" table. We are trying to show assignement_group,assigned_to values from task. we dot walk to that field. Values are visible in report from admin view but not from agent/itil/non admin view. ADMIN VIEW NON A...
Hi, We have a couple of chart reports that show true/false counts. In the Style, we used the default color scheme. In one report, the True count in the bar is green and the false is blue. In the other the false is green and the true is blue. How can ...
I am struggling to figure out a way to get the following indicators set up: - Average time to respond to an inbound enquiry - Average time to respond to assigned incidents The 'Assigned to' field signifies that an Incident has been actioned/responded...
Is there a way to edit coloring rules for pie charts? I see the option is available for other types of reports (single score, multilevel pivot, etc...) but it's not available for pie charts. I need to set some simple conditional formatting rules, suc...
Hii all, We do have requirement that emails need to triggered to users when they have created scheduled reports. We could see emails triggered in the email logs, but the type is "send-stagging" and state is "stagging" and they were are not sent to u...
Not able to download .Jpeg \ .png images from ServiceNow Dashboard. No option available to download as JPEG/PNG
Hi forum, I can't figure this out. When creating a report (pie chart) based on task_sla table, I am able to choose Group by and dot-walk to Task > Incident > Priority (first screenshot). However, I can't do the same from Additional group by (second s...
I would like to create a yearly report that shows all the tickets my team members opened, closed, resolved, or updated any work note information on. I can easily generate a report to show number of tickets opened, closed, or resolved. What I can't f...
How can I reference the fields in the sc_task table from the sc_req_item_sla or task_sla tables? I built an SLA report using the Task SLA table and I need to add several fields of data to my report from the sc_task table. The fields are as follows: ...
Hi Folks, I was trying to do an if else in formula indicator but its not really working as intended.The idea was that if a reference indicator = 0 then return 100 else proceed with the formula indicator1/indicator2.Here's the formula:var sla = [[indi...
I have two import tables and two target tables. One import table is extending the other import table, so they are using the exact same columns. The target tables are completely separate. I have a scheduled data source import set up for the "parent" i...
Indicator Source : Daily Job : Daily. Widget timeline : By monthly sum + Widget visualization : Line I ran the historical job for Closed Tickets. Result : It seems like the scores collected daily are being summed up and showing a very high number wh...
How do I put custom duration for a report of Aging incidents for example 2-3 days, 3-5 days, 5-10 days etc.
