5 Replies Latest reply on Aug 25, 2017 6:14 AM by Mangal Pandey

# In what situations would one turn a dimension to a measure, and vice versa?

I know one example is latitude because you can turn latitude = dimension to a metric even when the metric is degrees. I still don't really get that example and don't understand  in which situations a dimension would need to turn to a measure. Can anyone explain?

• ###### 1. Re: In what situations would one turn a dimension to a measure, and vice versa?

there are so many situations,

eg. I often see client_id going to measure but I know its discrete because I do not want sum or avg of client_id,

sometimes the postal code went to measures which I manually convert to dimension,

but I rarely see a measure going to dimension, because I think tableau is smart enough to put all numbers in measures pill.

sometime you want numeric values for window_sum like window_sum (count(client_id)) then I can pull it to measure

• ###### 2. Re: In what situations would one turn a dimension to a measure, and vice versa?

But aren't postal code and Client_id numbers or numeral? I thought metric = quantitative and dimension = qualitative (device category, etc) .

• ###### 3. Re: In what situations would one turn a dimension to a measure, and vice versa?

that is a great question.

tableau interprets numbers as measures, and it will sum them up.

so you may think that a postal code is a number but we don't expected its sum.

but tableau did not understand it.

so the best way is to assign such numbers into discrete and move to dimensions

2 of 2 people found this helpful
• ###### 4. Re: In what situations would one turn a dimension to a measure, and vice versa?

Thanks!

• ###### 5. Re: In what situations would one turn a dimension to a measure, and vice versa?

hope ur doubt is clear...

let me know if any more doubts...

1 of 1 people found this helpful