Issues with the Range value in Tableau

Question

What I want?

Create visualization out of the below excel table in Tableau.

What I did?

I added this table to Tableau, but it showed Salary values as String, thus placing it under the dimension tab instead of measure.

My Query:

Can someone suggest me how can I covert Salary range values to Int ?

Answer 1

One of the best solution is to have a seperate min_salary column and a max_salary column

If you don’t want to revise the incoming data, you can get the same effect using the Split() function in a calculated field from Tableau to derive two integer fields from the original string field.

For example, you could define a calculated field called min_salary as INT(SPLIT([Salary], ‘-‘, 1)). Split() extracts part of a string based on a separator string. Int() converts the string to an integer.