Subscriptions and alerts in Tableau - Cell-by-Cell Formula Trace

Sample Data

Daily sales data for a product over four days.

Cell	Value
A1	Date
B1	Sales
A2	2024-01-01
B2	500
A3	2024-01-02
B3	700
A4	2024-01-03
B4	300
A5	2024-01-04
B5	900

Formula Trace

IF SUM([Sales]) > 800 THEN 'Alert: High Sales' ELSE 'No Alert' END

Step 1: SUM([Sales])

Step 2: 900 > 800

Step 3: IF TRUE THEN 'Alert: High Sales' ELSE 'No Alert' END

Cell Reference Map

    A       B
1 | Date  | Sales |
2 | 01-01 |  500  |
3 | 01-02 |  700  |
4 | 01-03 |  300  |
5 | 01-04 |  900  | <-- SUM([Sales]) references B2:B5

The formula sums the Sales column (B2 to B5) to check if sales exceed 800.

Result

    A       B           C
1 | Date  | Sales | Alert Status       |
2 | 01-01 |  500  | No Alert          |
3 | 01-02 |  700  | No Alert          |
4 | 01-03 |  300  | No Alert          |
5 | 01-04 |  900  | Alert: High Sales |

The alert status column shows 'Alert: High Sales' only for the day where sales exceed 800.

Sheet Trace Quiz - 3 Questions

What does the formula check in the data?

A If total sales for a day are greater than 800

B If sales on 2024-01-01 are greater than 800

C If average sales are less than 800

D If sales on 2024-01-03 are exactly 800

Key Result

IF SUM([Measure]) > Threshold THEN 'Alert Message' ELSE 'No Alert' END

Practice

1. What is the main purpose of subscriptions in Tableau?

easy

A. To create new dashboards automatically

B. To send scheduled dashboard snapshots to your email

C. To instantly notify you when data changes

D. To share dashboards only within Tableau Server

Solution

1. Step 1: Understand what subscriptions do

   Subscriptions send dashboard snapshots on a schedule to your email, so you get updates without opening Tableau.

2. Step 2: Differentiate from alerts

   Alerts notify instantly when data meets conditions, not on a schedule.

3. Final Answer:

   To send scheduled dashboard snapshots to your email -> Option B

4. Quick Check:

   Subscriptions = Scheduled emails [OK]

Hint: Subscriptions send emails on schedule, alerts notify instantly [OK]

Common Mistakes:

• Confusing alerts with subscriptions
• Thinking subscriptions notify instantly
• Believing subscriptions create dashboards

2. Which of the following is the correct way to create an alert in Tableau?

easy

A. Right-click a continuous axis and select 'Create Alert'

B. Click 'Subscribe' on the dashboard toolbar

C. Export the dashboard as PDF

D. Use the 'Data Source' tab to set alert conditions

Solution

1. Step 1: Identify how alerts are created

   Alerts are created by right-clicking a continuous axis or measure and choosing 'Create Alert'.

2. Step 2: Eliminate incorrect options

   Subscribing sends scheduled emails, exporting PDF does not create alerts, and 'Data Source' tab is not for alerts.

3. Final Answer:

   Right-click a continuous axis and select 'Create Alert' -> Option A

4. Quick Check:

   Create Alert = Right-click axis [OK]

Hint: Alerts come from right-clicking continuous axes [OK]

Common Mistakes:

• Choosing 'Subscribe' instead of 'Create Alert'
• Trying to create alerts from data source tab
• Confusing export with alert creation

3. If you set an alert on Sales > 10000 and the sales data changes from 9000 to 12000, what happens?

medium

A. The alert is deleted automatically

B. You get a scheduled subscription email later

C. You receive an instant notification email

D. Nothing happens until you refresh the dashboard manually

Solution

1. Step 1: Understand alert trigger conditions

   Alerts notify you instantly when data meets the set condition, here Sales > 10000.

2. Step 2: Apply the condition to the data change

   Sales changed from 9000 (below threshold) to 12000 (above threshold), so alert triggers immediately.

3. Final Answer:

   You receive an instant notification email -> Option C

4. Quick Check:

   Alert triggers instantly on condition met [OK]

Hint: Alert triggers instantly when condition is met [OK]

Common Mistakes:

• Thinking alert waits for subscription schedule
• Believing manual refresh is needed
• Assuming alert deletes itself

4. You created an alert but never receive notifications. What is the most likely reason?

medium

A. The alert condition is never met by the data

B. You forgot to subscribe to the dashboard

C. Alerts only work on discrete fields

D. You must refresh the dashboard manually to get alerts

Solution

1. Step 1: Check alert condition relevance

   If the alert condition is never true, no notification is sent.

2. Step 2: Understand alert requirements

   Alerts work on continuous fields, subscriptions are separate, and manual refresh is not needed for alerts.

3. Final Answer:

   The alert condition is never met by the data -> Option A

4. Quick Check:

   No alert if condition false [OK]

Hint: Alerts need condition met to send notification [OK]

Common Mistakes:

• Confusing alerts with subscriptions
• Thinking alerts work on discrete fields
• Believing manual refresh triggers alerts

5. You want to receive a weekly snapshot of a sales dashboard and immediate alerts when sales exceed $50,000. How should you configure Tableau?

hard

A. Create only a subscription with a filter for sales > 50000

B. Use subscriptions only, as alerts cannot be combined with subscriptions

C. Set an alert for weekly notifications and subscribe for instant alerts

D. Create a subscription for weekly emails and set an alert on sales > 50000

Solution

1. Step 1: Understand subscription purpose

   Subscriptions send scheduled snapshots, so weekly emails require a subscription.

2. Step 2: Understand alert purpose

   Alerts notify instantly when data meets conditions, so set alert for sales > 50000.

3. Step 3: Combine both features

   Use subscription for weekly snapshots and alert for immediate notifications simultaneously.

4. Final Answer:

   Create a subscription for weekly emails and set an alert on sales > 50000 -> Option D

5. Quick Check:

   Subscription + alert = weekly + instant updates [OK]

Hint: Use subscription for schedule, alert for instant notify [OK]

Common Mistakes:

• Trying to use subscription for instant alerts
• Believing alerts can schedule emails
• Thinking subscriptions and alerts cannot be combined