Combine multiple values to display as one value in graphs and charts

[Brian Fornelius]

Hi there,

Not sure if the correct way to go about this.  kind of like an If Then statement

I have a table where I have multiple values.   For example.   I have a table with a grade field.  However people have entered in values like.

A

Grade A

B Grade B

C

and so on.   I trying to create a chart where I can combine the 'A' and 'Grade A'.  like

If Grade is 'A' or 'Grade A'

then 'A'

end

Is this even possible in ServiceNow Platform Analytics or better yet in UI Builder?

Thanks,

--Brian

[Slava Savitsky]

Sound like a use case for a function field.

[Brian Fornelius]

thanks for the info.   the ling shows me what it is but how do I go about doing that.   I have never created one in Service Now.

Thanks,

--Brian