So I have a set of data which when imported to Tableau does not behave like it supposed to. Some of the fields which were supposed to be Measures are turned into Dimensions automatically, and I have to change them to a Measure manually while I am starting off to create the dashboard. I was wondering, like, how does this changes the Measure Value in Tableau. Does it increase/decrease depending on the value of the Dimensions I converted into a Measure? Or does it simply represents the aggregate value of the default Measures when the data was first imported?
Changing a numeric dimension to a measure value does not change its value in any way. E.g. A dimension having a value 12345 when converted to a measure will have the value 12345 itself.
Changing a non-numeric dimension to a measure value however will change it to a count of the distinct values of the dimension.
Become a Viz Whiz on the Forums! Support the Community and master Tableau.