TABLEAU QUESTIONS

How Do You Send Tableau Subscription Emails with Saved Filters?

Your manager has filtered the dashboard to her region, but Monday’s email shows the whole business. Now she needs another report before she can prepare for the sales meeting.

Advanced Tableau Report Scheduler (ATRS) can keep the regional report values, Excel preparation and delivery together, so the weekly email contains the version each reader needs.

  
THE PROBLEM AND ANSWER

Why the email has lost your manager’s region

Imagine your regional sales manager opening her weekly email. On Friday, she chose her locations and the reporting week in Tableau, and the figures looked right. On Monday, the attachment is back to showing every region. She asks you to send her version, and you find yourself repeating the same selections before the meeting.

The subscription has not remembered the open browser tab. Tableau needs those saved filters in a Custom View that the subscription can use when it prepares the next email. Once you know that, the first part of the solution is straightforward.

Open the published view, choose the manager’s region and reporting period, then select Save Custom View. Give it a recognizable name, such as My Region — Weekly Sales. Open that saved view before choosing Watch → Subscriptions and subscribing to the current view.

A teal funnel, bookmarked report card, envelope and clock illustrate saving a filtered view for recurring email.

Save the regional selections you want the recurring email to use, then subscribe to that saved view.

For the manager’s regular image or PDF, that may be all you need. When finance asks for the same regional figures in Excel, or several managers need their own versions, ATRS can take over more of the weekly preparation. The region, report output and email destination then belong to a maintained Tableau Cloud reporting job.

Saved filters, defaults and access

Tableau’s Custom Views guide explains saving interaction state without changing the published workbook. Making a view your default is optional; choose the intended saved view for the subscription itself.

The subscription instructions explicitly require a Custom View for filtered subscriptions. Recipients need View and Download Image/PDF permissions, and subscribing others depends on the appropriate role and ownership.

A saved regional filter is a report selection, not an access rule. Keep the underlying permissions appropriate for each reader. Check workbook-wide output separately rather than assuming the current view’s saved state defines every sheet.

Choose a figure she will recognize

Pick one location’s sales total from the manager’s region. Finding it in the received attachment gives you a useful way to compare Monday’s email with the view she saved.

  
YOUR OPTIONS

Will a saved Tableau view do the job?

You may already have enough in Tableau for a recurring regional snapshot. A Custom View preserves the selections, and its subscription emails the image or PDF. If that is what your manager wants, there is no need to make the routine more complicated.

The requirement changes when finance asks for an Excel workbook it can sort and reconcile. Someone now has to export the regional figures, prepare the file and send it from the operations mailbox. Repeating that work every Monday is a good reason to bring it together in ATRS.

It also helps when the other regional managers ask for the same service. With an ATRS data-driven schedule, a maintained record can hold the region and recipient together. The reporting job can use those values to prepare each manager’s version, rather than leaving you to change the filters and addresses one email at a time.

Before building the weekly job, settle what the reporting week should mean. Your manager probably wants the period to move forward each Monday. Saving an absolute date gives her that particular week again. Agree the advancing date rule with the report author, so the file continues to answer the question she is asking.

Keep saved views working after workbook changes

Tableau’s maintenance guidance identifies changes that can break or alter Custom Views: workbook/sheet renaming, hidden sheets, replaced data sources, removed fields and some parameter or filter changes. Test representative saved views before publishing a relevant change.

A changed default can also affect a view that relies on it. When the regional choice must stay explicit, check the actual saved value rather than assuming a new workbook default is harmless.

Deleting a Custom View deletes subscriptions based on it. Review ownership before removing a user whose saved views others rely on. These are reasons to maintain the reporting configuration, even when the emails continue to arrive.

ATRS jobs also need retesting after source changes. Confirm the report path, supported parameter names, date rules and delivered output; a working email destination does not establish that the region is still correct.

Ask what finance does next

Does someone copy the regional sales into an existing workbook, rename its tabs or tidy the number formats? Those are useful parts of the Monday routine to include when you set up the Excel delivery.

  
SET IT UP

Give finance the same regional figures in Excel

Begin with the regional sales report and your own test mailbox. You want to open the same workbook finance will receive and see the figures your manager already recognizes.

Create an ATRS Single Schedule, select the linked Tableau Cloud account and choose the report’s Item Path. In Report Parameters, add the region and reporting-period values supported by the published report. The author may have provided parameters that control those selections; use their actual names and types.

ATRS Single Report Schedule Wizard Parameters tab with name, value, type, Add and Preview controls.

Enter the parameters exposed by the published report and preview their effect before configuring delivery.

Preview the regional report, then add its Email destination and choose Excel output. Write the short message finance needs: which region the workbook covers, which week it represents and what the file is for. Select the approved sending account so the delivery becomes part of the operations routine.

This is also the point to include the workbook preparation you discussed with finance. ATRS offers Excel and Excel Data Only output. You can give the tabs useful names, protect the workbook and, with Data Only, place the figures in an existing template with the required totals and column formats. Finance can receive a file ready for its next task instead of another export to tidy.

For the first run, use a week whose figures you know. Open the attachment from the test email and find the manager’s location total. Look at the dates and the cells finance will use. Then try the next reporting period, so you can see the weekly rule moving forward.

Once that works, set the Monday recurrence in the intended time zone and switch to the agreed recipients. If the other managers need separate files, extend the routine with their region-and-recipient records. Keep the response to a blank or failed report with the job, so you know who will hear about a problem.

Excel preparation and delivery options

The ATRS Excel guide covers Excel and Excel Data Only XLSX outputs. Both offer worksheet naming, workbook passwords, file properties and custom output naming. Data Only adds template worksheet placement, a starting row/column or next available position, selected totals, reusable styles and typed column formats.

Finance can therefore receive a regional workbook with recognizable tabs and data placed in its existing template. Check the cells, dates and totals rather than expecting an Excel export to reproduce the dashboard’s visual layout.

Package schedules can send several report attachments or merge Excel outputs into one workbook. File names can include inserts and date/time suffixes; configured ZIP/password or PGP protection can be applied where required. Add another configured destination when an archive copy is needed.

Use the Single Schedule guide for report inputs, preview and test delivery. Check the current installation prerequisites and make templates and destination paths available to the scheduling service.

Open the attachment, not just the preview

Finance works with the workbook that arrives in its inbox. Use that copy to see whether the dates, tabs and regional figures are ready for the reconciliation someone would otherwise do by hand.

  
FOR DEVELOPERS

Let your portal send the manager another copy

Your reporting portal may offer the manager a way to request another copy before a meeting. It can ask ATRS to run the saved regional job, while the reporting team keeps the report values, workbook preparation and destinations in ATRS.

The portal’s part is to connect the signed-in manager with the job she is allowed to request. That means she can ask for her regional workbook without someone rebuilding the export or relying on the filters left open in a browser.

API example: request the saved regional report

Follow the ATRS execution guide. This example runs an ordinary single-report schedule. Replace 101 with its actual UniqueId, use your ATRS HTTPS address and keep the token on the authorized backend.

POST /api/Schedule/ExecuteScheduleAsync
Authorization: Bearer <ATRS-access-token>
Content-Type: application/json

{
  "ScheduleType": "report",
  "UniqueId": 101,
  "RunBy": "Regional reporting portal"
}

GET /api/Schedule/GetExecutionStatus?ExecutionId=<returned-id>
Authorization: Bearer <ATRS-access-token>

Save ExecutionId with the requested region and week. Monitor within a defined limit and parse the JSON-encoded ResultJson; Completed can contain Result=false. Check the delivered workbook before presenting it as the requested regional report.

The execution payload does not supply new region/date overrides or recipients. For fixed regional needs, separate configured jobs can keep requests independent. Avoid changing a shared schedule’s region while another request may be executing it.

When an application manages configuration updates, follow the relevant complete update contract and coordinate changes before execution. Do not treat a read response as a safe replacement payload or assume unspecified settings and destinations will be preserved.

Reconcile earlier execution activity and destination evidence before retrying an uncertain submission. A lost response does not prove that the file was never generated or sent.

Help a colleague find the extra copy

Keep the manager’s region, reporting week and execution reference together. If she asks about a missing workbook, a colleague can find the particular run she requested.

  
YOUR NEXT STEP

Bring the conversation back to regional sales

Return to Monday’s sales meeting. Your manager opens the email and finds her locations and the week she expected. Finance has the matching workbook, and the conversation can move on to the sales results instead of another request to export the report.

Start with one regional email you currently correct or prepare by hand. A saved Custom View and native subscription may cover the snapshot. When the job also needs workbook preparation or separate versions for several readers, use that same report to evaluate ATRS.

Explore how ATRS can keep each reader’s report values and delivery together, then build out from the Monday routine you already know.

Explore ATRS personalized report delivery

Contributors:

Christian Ofori-Boateng

Christian Ofori-Boateng

CEO, ChristianSteven Software