Report Issue - How to change Legend Label in reports?

[shanker1]

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

[srinivasthelu]

Hi Shankar,

I have taken below lines from the wiki

2.3.1 Relabeling a Column

In some cases, two different tables may have fields of the same name that are both important (such as two tables with a sys_updated_on field).

To create clear reports, relabel the fields on the Database View [sys_db_view] table without changing the names of the fields:

1. Navigate to System Definition > Language File.
2. Click New.
3. Fill in the form as follows:
   • Table: Name of the database view
   • Label: Display label
   • Plural: Plural form of the display label
   • Element: Name of the field on the database view

It seems You need to create a new Field label for has_breached element on the incident_sla database view

Thanks

Srini

Mark this response as helpful/correct if it does so

[shanker1]

Thanks Srinivas. I'm actually using a view to get the below chart displayed. It is Grouped BY assignment group and stacked by "Has Breached". So in the legend its actually displaying the values of Has Breached field and could be seen in the screenshot. So i feel, another field(breached status) have to be created in the task_sla table and which has to be updated like, when hasbreached status is true, then breached status=SLA not met and hasBreached is false then breached status= SLA met

.

[srinivasthelu]

Got it.

Yes. You might need to add new field. I think you can create calculated field here

Calculated [Advanced view]

Determines whether the value of the field is calculated from other values. If selected, use the Calculation field to define how the calculation is performed. When sorting or grouping by a calculated field, the sort order is based on the field value from the last time the field was updated, not the last time the field was displayed. Note: In relation to business rules, calculated fields are populated first before any business rule, even a before business rule, is run. Calculated fields are then populated again if necessary after any before business rules run.

Calculation [Advanced view]

When the Calculated field is selected, allows you to enter a script for calculating the value of the field. You can use the current object in this script. Set a field value directly, such as: current.display_name="name". Note: You can override the calculation for extended tables.

Thanks

Srini

[Pradeep Sharma]

Hi Shanker,

I don't think there is a easy way for this req. You may have to create a custom field on your table and populate the field for all the records via one time script.

You have to also take care to hide this field from the form.

Please let me know if you have any questions.