I am trying to build a dashboard for my company. However, in order to do that I need to create a dataset. One of the fields that I need to draw for my dataset is an object of picklist type, which outputs API names.
I would like to get the user values that you would see in a Salesforce report, but I haven't been able to come up with any way of doing so in the datflow.
I have been trying to use the following SAQL expression inside the dataflow with no results
All the previous questions that dealt with a similar problem seems to offer it as the answer, but is not working for me.
Any help would be greatly appreciated. Please let me know if more details are needed to answer the question.