Report Issue - How to change Legend Label in reports?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2016 07:52 AM
Hi,
I'm generating a Bar chart to get the list of incidents that are breached and not breached by assignment group. I'm stacking by hasBreached field. So the legend of the report shows as false and true. Can this legend label be changed to SLA met and SLA not met?
Thanks,
Shanker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2017 04:08 AM
Hi,
Not sure if this is still an issue, however I had a similar issue and used "report ranges" to rename the labels to the values I wanted, it also allowed me to specify the colours I wanted as well... Hope it helps.
Report Ranges - ServiceNow Wiki
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-20-2019 08:28 PM
Hi Shanker,
This looks to be an old post. But, still I thought of posting how I achieved. I have created data sets and hence was able to achieve the requirement where we don't want true/false to appear, instead a label which makes the end user understand what it actually is. please find below screenshot. In your main report you can give condition of has_breached is true and for the dataset you can condition as has_breached is false. Name of you data set appears as label(instead of true or false). Let me know if anyone needs more info on this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2019 05:12 PM
HI ,
This looks good, i was trying to make changes in my report, as per above instructions was able to make changes in has_breached is true but unable to find dataset option to make changes. Or do we have any other option
Please suggest.
Thanks in advance,
Sunali
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2019 06:10 AM
I know how to create a new report data set, but I still cannot figure out how to change my true/false labels to the text I want.
Can you please advise how you did that?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2019 08:29 AM
Here's how I was able to do it:
(Note: I start creating the report in Classic UI. I find it easier, but if you can find your way around in the new UI, you can do that too.)
1. Go to Reports -> Report Sources
2. Create two sources, for instance: Incident SLA Breached and Incident SLA Not Breached; add your conditions and filters here, and then you won't need to add them later in the report itself
3. Create a report:
- Give it a name
- In Data, choose Report Source
- Click on the magnifying glass and find one of your newly created report sources. I chose the one called "Incident SLA Not Breached"
- Choose your Type; I chose Column
- If you can or want to configure the colors, click on the configuration wheel and change them
- Click on the dropdown arrow near the Save button and choose Multiple Dataset
- Give the Series a name. This name will be your label. So if you chose earlier the one called "Incident SLA Not Breached", call this one "SLA Breached"
- In Data, choose Report Source and proceed to choose the "Incident SLA Breached" one you created earlier
- In Type, choose the same type as the one in the report you created
- Chart color - change it if you want
- Click save and then "X" to close
Both in the report and in the dataset you created you do not need to add filters, because you probably added them to the dataset you created in step 2
Now, if you look at the report, you will see that one label is "SLA Breached" but the other one is something like "Incident SLA false" or something like that. To change it, (now this is where it gets weird a bit 🙂 😞
- In your report, switch to the new UI
- Under Data, add or change the Dataset name (left side of the screen) to the label you want to appear in the report
- Click Save
Enjoy.
harel