Why calculations extend data analysis in Tableau - Dashboard Impact

Dashboard Mode - Why calculations extend data analysis

Business Question

How can calculations in Tableau help us understand sales performance better than raw data alone?

Sample Data

Order ID	Region	Category	Sales	Profit
1001	East	Furniture	300	50
1002	West	Technology	450	120
1003	East	Office Supplies	150	30
1004	South	Furniture	200	40
1005	West	Office Supplies	100	20
1006	South	Technology	500	150
1007	East	Technology	400	100

Dashboard Components

• KPI Card: Total Sales
  Formula: SUM([Sales])
  Result: 2100
• KPI Card: Total Profit
  Formula: SUM([Profit])
  Result: 510
• Calculated Field: Profit Ratio
  Formula: SUM([Profit]) / SUM([Sales])
  Result: 0.2429 (24.29%)
• Bar Chart: Sales by Region
  Formula: SUM([Sales]) grouped by [Region]
  Results:
  • East: 850
  • West: 550
  • South: 700
• Calculated Field: Sales Growth Indicator
  Formula: IF SUM([Sales]) > 400 THEN 'High' ELSE 'Low' END
  Used to color bars in chart

Dashboard Layout

+----------------------+----------------------+
|   Total Sales (KPI)  |   Total Profit (KPI)  |
+----------------------+----------------------+
|          Sales by Region Bar Chart           |
|                                              |
+----------------------------------------------+
|           Profit Ratio (KPI) Card             |
+----------------------------------------------+

Interactivity

A filter on Region allows users to select one or more regions. When applied:

• Total Sales, Total Profit, and Profit Ratio KPIs update to reflect only selected regions.
• Sales by Region bar chart updates to show bars only for selected regions.
• Sales Growth Indicator recalculates to color bars based on filtered sales values.

Self Check

If you add a filter to select only the East region, which components update and what are their new values?

• Total Sales: 850
• Total Profit: 180
• Profit Ratio: 180 / 850 = 0.2118 (21.18%)
• Sales by Region Chart: Shows only East bar with sales 850 colored 'High'

Key Result

A Tableau dashboard showing total sales, total profit, profit ratio, and sales by region with interactive filtering to extend data analysis using calculations.