Platform Analytics forum
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Reports to compare the value of two different column

Dear Experts, We have a requirement to add report in the dashboard to compare and check the value of 2 different column, Example Actual vs Budget. Could any one suggest how we can do this from servicenow reports. If not possible, what is the best to ...

sri86 by Tera Contributor
  • 2925 Views
  • 6 replies
  • 1 helpfuls

How to add colour in the report based on condition.

Dear Experts,  I am using Multi Pivot Report, I have an requirement to display the value with different colour. For Example I have columns like Employee, Location, Manager, Month, Actual, Budget and Total. In report I am displaying Location wise, Man...

find_real_file.png
sri86 by Tera Contributor
  • 1808 Views
  • 1 replies
  • 0 helpfuls

Left Joining Problem on Database View

Hi, I've tried all sorts before coming here so I hope someone can help me. I have a very simple table report that shows the number of incidents tickets per customer across the top and per assignment group down the side.   As normal, if a customer has...

Resolved! Report by Resolved Date

I'm trying to build a report which shows the Resolved Date. I can't seem to find that as an option anywhere when setting it up. Can anyone point me in the right direction? 

find_real_file.png
Cat by Mega Guru
  • 2154 Views
  • 1 replies
  • 0 helpfuls

Resolved! what is the Demand field 'approval_set'?

There is a field on the demand table - 'approval_set'. I'm trying to confirm if this is an OOB field? If it is, is it populated for you? and if so, what is approval set? I'm ultimately trying to find a field that holds the approval date for the deman...

Resolved! breakdown relation on dot walked fields

I am trying to create a breakdown relation on a formula indicator. The individual breakdowns are dot walked from the location field on the original records and work correctly on the top level indicator. However, the breakdown relations do not work co...

aaronelder by Mega Expert
  • 2953 Views
  • 5 replies
  • 0 helpfuls

Outage Tasks Link to Incident to Problem

I'm feeling very confused at the moment I need to create a report that shows all incidents that meet a criteria including data from the related problem record. So far so easy, dot walk from incident to problem and job done. However, the criteria for...

Resolved! Custom report on how long task has been opened

We have a request process that the completion of the task needs to happen in 3 days. Our customer wants a dashboard to display a pie chart that shows all those tasks that have been opened for 1 day, 2 days, 3 days, and more than 3 days. They want eac...

find_real_file.png
emma_hunt by Giga Contributor
  • 4942 Views
  • 5 replies
  • 6 helpfuls

combining SLA and Metric tables for reporting

moving from old ITSM system that produced a single SLA and metric (MTTR) per incident.  This was used to produce reports that would show an inicident's SLA and MTTR compliance in a single view.   Is there a dashboard or other mechanism that would all...

Labels