Hello - I am trying to create a report that will give me % of incidents that has a problem. The issue of grouping by the Problem field is that it shows empty and a bunch of problems instead of a group of problems. I wanted to use function field available in the report to create True and False values. Did anyone ever got this working?
So as you probably already know, those function fields only have VERY VERY simple options. I liken them to transform only... you can't use *logic* to change anything.
I went with this. If you take the length of any reference field you get 32 (length of a sys_id). So I'll know an Incident is linked to a problem if (length of problem reference) / 32 = 1. So I made a function that does exactly that.
And that yields a report that looks like this...
Which, if you make a pie chart out of....
I changed the label of the report so it reads better. The 1 and 0 aren't great series labels... but I don't know any other way to do it.
So as you probably already know, those function fields only have VERY VERY simple options. I liken them to transform only... you can't use *logic* to change anything.
I went with this. If you take the length of any reference field you get 32 (length of a sys_id). So I'll know an Incident is linked to a problem if (length of problem reference) / 32 = 1. So I made a function that does exactly that.
And that yields a report that looks like this...
Which, if you make a pie chart out of....
I changed the label of the report so it reads better. The 1 and 0 aren't great series labels... but I don't know any other way to do it.
Used this thread to come up with this, which returns a true/false.
