InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What are the different aggregation types used in Tableau? |
|
Answer» Tableau support below aggregation types: sum, average, median, count, count distinct, standard deviation, variation, minimum, maximum, standard deviation of a population, variance of a population, attribute (ATTR), dimension. Aggregation in Tableau can be performed on measures and dimensions both. It is more common in measures. When we create a MEASURE in the view, aggregation is ALREADY applied to its VALUES by Tableau. So “Revenue” will become “Sum(Revenue)”. Typically “Sum” is the default. Else other aggregations such as Average, Median, Count, Count(Distinct), Minimum, Maximum, Percentile, Std. Dev, Std. Dev(Pop.), Variance, Variance(Pop.) can ALSO be selected from the list. These options are primarily for measures. For dimensions, we can have aggregation types as minimum, maximum, count, count distinct etc. |
|