Custom sorting of a dimension in a bar graph

[#1]

Got a graph that looks like this:

I want to sort the dimensions in the following order:

Offered/Hired

Hiring Team Interview

HR/Tech Screening

New Applicant

[pover · Accepted solution]

It would be excellent if you could assign a number value to these concepts from the data modelo so that you can just sort on that value, but if not in the sort tab, select the dimension and enable the option to sort by expression.  The expression is going to be:

=match(DimensionField,'Offered/Hired','Hiring Team Interview','HR/Tech Screening','New Applicant')

The match function returns the number in the list where the dimension value is found.  For example Offered/Hired will return a 1 and HR/Tech Screening will return a 3.  This should allow you to sort the graph in the way you order your match list.

Karl

[#3]

Thanks!  Match() worked well.  Yeah, I'm aware I could assign values to them... But my client has a static Excel file, doesn't want to be touched.