When creating a report and you group by on a field. If the data in the field is empty the report will create a group labeled (empty). Is there a way to change this label to (In Progress) instead?

[plallema]

Colleague is generating a report of Incident calls group by Resolution code. As there are Incident tickets that haven't been closed yet so the resolution code is null or none. When generating the report it classifies the null group as "(empty)" which would be misleading to senior management. Is there a way to change the label for the null or empty group to "(In Progress)"?  

[lgustafson · Accepted solution]

I would handle this by

1) Creating a resolution code called "In Progress"

2) Setting this as the default resolution code value

3) Hide this value from the choice list using a client script at the point in the process when the resolution code must be chosen

[plallema]

Thanks Lesley, this seems like the viable solution. Didn't want to have to write a script and since resolution code is dependent on subcause code, I would have to do it for every possible subcause code. Going to try to sway my colleague to filter out non closed incidents as Paul suggested below. Thanks Again

[postwick]

Why not just filter the report so it only includes closed Incidents?