How to avoid aggregation of measure values in tableau

tableau-api
Gowtham Ramamoorthy picture Gowtham Ramamoorthy · Apr 14, 2017 · Viewed 7.7k times · Source

I'm trying to retrieve and analyze records from SQL server. Whenever I drag the measure values to rows field it gets auto aggregating itself in tableau.

I dont want this aggregation to be done since my values doesn't make sense when it gets agregated.

enter image description here

Is there a solution to remove this aggregation in tableau ?

Thanks

Answer

emh picture emh · Apr 14, 2017

Yes, you can avoid aggregating values. However, your problem isn't that you are aggregating your values, your problem is that you are treating dimensions as measures.

To fix this you can convert Year from a measure to a dimension:

enter image description here

Of course, if you want to disaggregate the measures then you can always do that too:

enter image description here

Related questions

How to display 40 + columns in Tableau?

I am trying to do a list report with about 40 columns(Dims+measure) but not able to get it right, the requirement pushes the Tableau limitation by exploiting its limit to only 16 columns. How can I get this done? I …

Read More
In tableau, how do you modify the number of decimals of a percentage label?

In tableau, how do you modify the number of decimals of a percentage label? On bar charts, histograms, maps, etc.

Read More
How do I show an axis in Tableau

How can I re-enable the y-axis on the following line graph? I have tried right clicking various places with no success.

Read More