Fortunately, you do not need to perform two operations. Then the results for each region must be derived, by averaging the results for the individual marks. To see totals that correspond to the numbers you see in your view requires two averaging operations in Tableau: first, values for the individual marks (or cells) in the view must be derived-for example, by averaging all values that have the properties Ship Mode = First Class, Category = Furniture, and Region = Central. The result is derived by averaging all values that have the properties Ship Mode = First Class, Category = Furniture, without regard to region. In this case there are more than four numbers to average, perhaps many more. The discrepancy is due to the fact that Tableau is averaging the data in the underlying data source. But if you compute the average for the four values you see in the row ($329, $306, $390, $348), the result comes to $343.25, not $339. The average that you see at the right of the first row under Grand Total is $339. When you first turn on grand totals, the totals are computed using disaggregated data in the underlying data source. Refer to Configure total aggregation to learn more. Source, and locally if you are connected to an Essbase data source, using Server if you are connected to a Microsoft Analysis Services data Note: By default, totals are computed on the In theįigure below, only column totals are calculated because the table You can also display totals for graphical views of data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |