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

Forum Posts

Incident Table- Made SLA Column

Hi All, In my report from service now for table 'Incident', Made SLA column is appearing as 'True' for all the INC's. Is it safe to assume that the SLA has been 'Met' as Made SLA is having value 'True' ?  

SiddhantT by Kilo Contributor
  • 875 Views
  • 1 replies
  • 1 helpfuls

Resolved! Incidents created 3,4 or 5 days ago

We're trying to pull reports of all incidents opened 3 days, or 4 days, or 5 days ago and using relative doesn't provide us with any data.  Using "Between" doesn't provide us with the options we're looking for. We're currently on the Kingston release...

troyjohnson by Kilo Contributor
  • 6757 Views
  • 6 replies
  • 2 helpfuls

World map not showing state level

Hi, I need some help with map report. I have created a Map report to show the incidents by caller’s location. I defined a 3-level map source record. Level 1 is caller location country; Level 2 is caller location state and Level 3 is caller location c...

Tanmay14_1-1706007209356.png Tanmay14_2-1706007302979.png Tanmay14_3-1706007653153.png Tanmay14_4-1706007768366.png
Tanmay14 by Tera Contributor
  • 1543 Views
  • 3 replies
  • 0 helpfuls

How to create a Monthly Backlog report

HelloWe need a monthly trending backlog report that shows incidents that are open for that point in time when the report is executed. If a ticket is open in Jan and Feb, then it would show for both months that it is open. See screenshot below.I thoug...

find_real_file.png find_real_file.png find_real_file.png
brandimore by Kilo Expert
  • 12392 Views
  • 16 replies
  • 2 helpfuls

Interactive filter on question table

Hi all,I need to create a interactive filter where it has to be interactive with report. The report consist of variable values which is dot walking through question table. The variable type is date. Can someone help me how to create an interactive fi...

Community Alums by Community Alums  
  • 394 Views
  • 1 replies
  • 0 helpfuls

Count Stores

Hello, I have a situation where a store will have multiple tickets open for the same configuration item. I'm trying to count how many stores have at least 1 open ticket as opposed to counting all open tickets. Any ideas how to do this? I've tried a p...

Resolved! ITIL User Count Month by Month

Hello, I need to get a month by month ITIL user count for the last year. The only way I can think of doing this is using the sys_user table but am having trouble with it.

Nick Lozano by Mega Contributor
  • 3031 Views
  • 11 replies
  • 1 helpfuls
Labels