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
But aren't postal code and Client_id numbers or numeral? I thought metric = quantitative and dimension = qualitative (device category, etc) .
2 of 2 people found this helpful
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
1 of 1 people found this helpful
hope ur doubt is clear...
let me know if any more doubts...