use the quick analysis button to sum the range

In the dialog box that opens, you can configure the following options: On the Marks card, right-click Sum(Profit) and select Edit Table Calculation. (Optional) Customize the quick table calculation The colors in the visualization update to show the moving average of profit across the years. Note: You can only perform quick table calculations on measures in the view.Ī delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average. The visualization updates to look like this: On the Marks card, click the Mark Type drop-down and select Square. Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.įrom the Data pane, under Dimensions, drag Order Date to the Columns shelf.įrom the Data pane, under Dimensions, drag State to the Rows shelf.įrom the Data pane, under Measures, drag Sales to Text on the Marks Card.įrom the Data pane, under Measures, drag Profit to Color on the Marks Card. Apply a quick table calculation to the visualizationįollow along with the steps below to learn how to apply a quick table calculation to a visualization. With traditional table calculations, you can apply the same settings, but you must apply them manually. They are applied to the visualization with the most typical settings for the calculation type you choose so that you can continue on with your analysis. Quick table calculations are table calculations that you can apply quickly to your visualization in Tableau. How does a quick table calculation differ from a table calculation?

The following quick table calculations are available in Tableau for you to use:įor more information about some of these, see Table Calculation Types. This article demonstrates how to apply a quick table calculation to a visualization using an example. Quick table calculations allow you to quickly apply a common table calculation to your visualization using the most typical settings for that calculation type.

Use the quick analysis button to sum the range