Jump to content

Reporting - Legend


Recommended Posts


I have created a fairly basic report.

The report lists all calls raised for certain departments, grouped by the field "Within Resolve Time"

This report is then represented by a Bar Chart

The issue we have is that the Legend returns the characters 0 and 1

Is there a way were we can amend to say : 

0 = SLA Breached  

1 = Within SLA

Otherwise the Report looks a bit unprofessional


Many Thanks




Link to comment
Share on other sites

Hi Colin,

There is no way to alter the data values. We do have a "data formatters" mechanism but i don't believe customers can set these up as they are locked down to the product teams. I will ask the SM product team if they can have a look at setting up data formatters for various 0/1 flags in the SM database schema.


Link to comment
Share on other sites

  • 4 months later...

Hi @colind

We've enhanced the value that is presented in Reporting for the following columns:

Formatter: Breached (0) / Met (1)

  • h_itsm_request_slm_targets.h_target_met
  • h_itsm_requests.h_withinfix
  • h_itsm_requests.h_withinresponse

Formatter: No (0) / Yes (1)

  • h_sm_request_approvers.h_flg_approvers_confirmed
  • h_itsm_requests.h_archived
  • h_itsm_requests.h_bpm_stage_expired

Formatter: Yes (1) otherwise always "null"

  • h_itsm_incidents.h_firsttimefix
  • h_itsm_incidents.h_flgfixisresolution
  • h_itsm_incidents.h_flgfixisworkaround
  • h_itsm_incidents.h_flgproblemfix
  • h_itsm_rel_requests.h_flg_acceptedsolution
  • h_sm_relationship_entities.h_flg_acceptedsolution

Formatter: Unlocked (0) / Locked (1)

  • h_itsm_requests.h_locked_details

Formatter: Scheduled (1) otherwise always "null"

  • h_itsm_changerequests.h_scheduled
  • h_itsm_releases.h_scheduled

Formatter: Historic (1) otherwise always "null"

  • h_itsm_requests.h_historic


These changes will be available in the next Service Manager update, which is scheduled to be available in the week commencing 16th October.



Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...