List for dashboard with different options than field values

I’m trying to create a dashboard for POs. One of the things that I’d like to do is have a filter that users can choose for the Approval Status. The statuses in the field are U, A, R, & P. But What I want the list to show is Unapproved, Approved, Rejected, & Pending.

I created an UltraCombo but that’s as far as I got before realizing it’s not intuitive.

Thanks for the help.

You could use a UserCode list, and use epiCombo object.
ex: ComboBox - UD Table or User Codes


@Machzy - You could add a calculated field to the BAQ that shows the Status as the “long text” instead of just the code. Then have your filter tied to the calculated field instead of the actual status field.

He already has the field and values he needs, so UD is overkill. He should just handle the display value on the BAQ level per @ckrusen suggestion.

Thanks @ckrusen, that’s what I ended up doing