Skip to main content

#Tableau Desktop & Web Authoring190 人がディスカッション中

Hi Community! 

 

I am having an issue with my dashboard that uses a parameter action to create a hierarchical drill-down in my Region worksheet

 

My setup:

  • My Region worksheet uses a parameter + calculated field to create a drill-down hierarchy.
  • Other worksheets in the dashboard are being used as filters that impact the Region worksheet.
  • The drill-down works correctly when interacting only with the Region worksheet.
  • However, when I apply a filter from another worksheet, the Region worksheet resets back to the top level.

The issue:

  1. I drill down in the Region worksheet (for example: Region → State).
  2. I select a value from another worksheet that is being used as a filter.
  3. The Region worksheet refreshes, and the drill-down collapses back to the top level.
  4. The filters that were applied are also reset.

My goal is to keep the filter applied while maintaining the current drill-down level, so that I can continue drilling down and selecting states within the Region worksheet. 

 

Is there a way to fix this so that the selecting the drilldown doesn't reset my filters? 

 

 

Thanks! 

 

How Can I Fix a Parameter-Driven Drill-Down From Resetting When Using Worksheet Filters in Tableau?

 

 

 

#Tableau Desktop & Web Authoring  #Tableau

4 件の回答
0/9000

Hi All,

 

I have the following columns in my table :

 

Weighted Average Calculation

 

I need to display weighted avg of these "Steps" per country and per instance type. I am attaching a sample worbook with desired view. For now I am just displaying the Avg in this view.

 

I need to calculate some sort of weight / frequency to calculate the weighted average I think ?

 

Can anybody help me with the formula for Weighted Avg?

 

Thanks,

Anusha H.

5 件の回答
  1. 7月24日 11:02

    This looks like a good example of why it helps to separate the raw data from the calculation logic. I would first make sure the values are being compared using the same unit and age/weight range, then calculate the result from the relevant data points rather than mixing values from different categories. A simple table or spreadsheet formula can also make it much easier to check the calculation and spot any unusual results. 

    For students learning this type of calculation, a step-by-step tool can be especially useful because it shows how the input values lead to the final result instead of just giving an answer. I’ve also found a pet weight calculator useful for demonstrating this kind of practical calculation—it can help users estimate a pet’s weight-related information from their inputs, while students can use similar examples to better understand units, averages, ranges, and basic formulas. It makes abstract math easier to connect with a real-world example. 

0/9000

Hello everyone, 

 

I searched the community first, but I could not find a matching thread. I would appreciate any guidance. 

 

Summary 

When I publish a workbook from Tableau Desktop to Tableau Cloud on my Mac, Tableau Desktop closes immediately. There is no error dialog. The same Tableau Cloud site works when publishing from another computer. 

 

Environment

 

- Apple MacBook Pro, Apple M5 Max 

- macOS 26.5.2 

- Tableau Desktop (Apple silicon) 

- Versions checked: 2025.3, 2026.1, 2026.2, 2026.2.1 

- Same behavior on all of these versions 

 

What I observe 

1. Open a workbook in Tableau Desktop 

2. Sign in to Tableau Cloud successfully 

3. Choose Publish Workbook 

4. Tableau Desktop closes right away with no message 

5. A diagnostic report file (.dmp) is created 

 

Useful details from the diagnostic report 

- Memory access exception 

- Signal 10 (SIGBUS) 

- Example product build: 20262.26.0708.1337 

- Architecture: arm64 

- Example correlation id: 099AF1D8AFE440838F45AF86D5D2F0DE 

 

From the Desktop log 

- Cloud sign-in completes 

- The app stops before a publish-workbook command is written 

- There is no normal close-log entry 

 

From the related protocol service log 

- AdminTask pipe closed, exiting 

 

What I have already tried 

1. Checked multiple Desktop versions listed above 

2. Tried a Redshift workbook 

3. Tried a text-file-only workbook 

4. Confirmed publishing works from another PC with the same Cloud site 

5. On this Mac, Publish Data Source as extract can succeed 

6. On this Mac, Publish Data Source with a live connection also closes unexpectedly 

7. Collected diagnostic report files and matching logs 

 

Questions 

1. Has anyone seen Publish Workbook close unexpectedly on Apple silicon / recent macOS? 

2. Which files are most useful to share for review? 

3. Is there a temporary workaround for Publish Workbook? 

 

Thank you very much for any help. 

 

#Tableau Desktop & Web Authoring

2 件の回答
  1. 今日、13:56

    @Masanori Hiroki

     

    Hi, in this case, I recommend you to create a support case: 

    https://help.salesforce.com/s/cases

     

     

    We have not seen a raising problem that describes what may be happenning. 

     

    Maybe it has to do with the built in Mac features killing the Tableau program (Security, Gatekeeper,XProtect) or maybe lack of permissions on Tableau program (Apple Menu  > System Settings > Privacy & Security) give Tableau full disk access. 

     

    If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you. 

     

    Regards, 

     

    Diego Martinez 

    Tableau Visionary and Tableau Ambassador 

0/9000
11 件の回答
  1. 6月21日 22:27

    Hi, @SSMK A

    How about trying the Viz Extension that Tableau provides? 

    There’s even a Sankey diagram available. 

     

    <viz extension> 

    https://exchange.tableau.com/products/932

     

    Hi, How about trying the Viz Extension that Tableau provides? There’s even a Sankey diagram available. <viz extension> https://exchange.tableau.

     

    Alternatively,  

    if you prefer to build it manually, you might find this reference helpful. Please take a look. 

    https://www.flerlagetwins.com/2018/04/sankey-template.html

     

     

0/9000

Hi, 

I have been using tableau for over 5 years and for some reason, I am finding something funny happening with simple table calculations only today. 

When I try to use a dimension in the colour after selecting say table across on a horizontal bar chart with a % of total calculation, the total is not coming as what it should. 

Has something changed in tableau in the very recent past please? 

I tried by putting things as text and the calculation comes fine, when I make it a bar chart, then things change. 

Can someone guide me on where I am going wrong please? This looks very simple and we use it everyday, yet for some reason I am seeing something missing today. 

I am attaching the workbook, please check the last sheet.  

This issue appears to occur only with some dimensions, with other dimension it works well. 

So what is it that I am missing here?  

 

 

#Tableau Community Updates  #Tableau Desktop & Web Authoring

3 件の回答
  1. 今日、11:19

    I do know what you are trying to do - the point is not necessarily to use an lod - I jsut did that to isolate the problem - which is some data is at a DATE level other data is at a level that is not date dependent and when you created your data model you effectively duplicated the data across dates - In the LOD model I just applied some year and month filtering to illustrate the problem

0/9000

I have been working on some custom color palettes for the community. The color palettes have been formed based on the color palette information found at http://mkweb.bcgsc.ca/colorblind/ for deuteranopia, protanopia, and tritanopia. Only colors which have passed the Color Contrast Analyzer with AA standards are included.

Colorblind Custom Color Palettes

 

For knowledge, I have only transformed those in the grey box and included if they should be used with a white or black background.

Picture1.png

 

Use the following instructions to make / modify your preferences file: https://onlinehelp.tableau.com/current/pro/desktop/en-us/formatting_create_custom_colors.htm#about-the-preferences-file

See the attached TPS file.

7 件の回答
  1. 今日、7:40

    Very useful resource for creating more accessible Tableau dashboards. I like that the palettes are tested for AA contrast and designed for different types of color blindness. The TPS file and setup instructions make it easy for others to use. 

0/9000

Hi, I have a question how do I hide a value from multiple dropdown list in the filter card while making sure that the value is checked and it is used in view. Just i dont want user to see that value. I am working on Tableau Desktop. Tried creating duplicate and set but they didn't work. Could someone please help me in this issue. 

 

#Tableau Desktop & Web Authoring

9 件の回答
  1. 昨日、6:46

    Tableau doesn't support hiding a single selected value from a filter card while keeping it applied. A practical workaround is to filter that value using a calculated field or data source/context filter, then expose a separate user-facing filter with only the remaining values. If you share your filter setup, we can suggest the best approach.

0/9000

Working in Tableau Desktop 2025.1.13, I am running into an issue with PDF export. I'd like the Total row to have a light yellow cell fill, as shown in the Desktop table shown below (with data redacted for this post). However, when I export the view to PDF, the yellow fill does not stay only on the cells with the measure names in the total row, i.e., Total Awards ($), % Change, and Total Awards (see second picture). This occurs with each of the following PDF export options: File -> Print to PDF; File -> Print ->  Adobe PDF; File -> Print -> Microsoft Print to PDF. Does anyone have a solution for this?   

Total Row Cell Fill Partially Dropping in PDF Export

 

PDF export with yellow fill on measure names dropped (with data redacted for this post)? 

image.png

 

 

 

#Tableau Desktop & Web Authoring

1 件の回答
0/9000
2 件の回答
  1. 7月23日 22:14

    Hi, @Tonmoy Dasgupta

    As Don mentioned, I think it would be wise to verify whether Data Blending is truly necessary. However, newer versions of Tableau now offer the following capabilities, so please review them and see whether they match your use case—for example, scenarios where you link existing data sources such as those already prepared in Tableau Cloud.

     

    <tableau help> Hi, As Don mentioned, I think it would be wise to verify whether Data Blending is truly necessary.https://help.tableau.com/current/pro/desktop/en-us/datasource_extend_compose.htmimage.png

0/9000

I'm having trouble with creating a MAX Item Cost and a Sum of the extended cost per part number. 

In my example, I have a part number that has many costs and would need to see the bottom as the outcome. I have tried to use the Table Calculations and max and sum respectively but it has not worked.  

 

How to get a max and column total

 

 

 

#Tableau Desktop & Web Authoring

1 件の回答
  1. 7月23日 21:36

    @Ashley Inman

    I'd probably (not having your real data, so just a guess) two new calculations using LOD (Level of Detail expressions): 

     

    Max Cost

    {FIXED [Part] : MAX([Cost])}

    Total Extended Cost

    {FIXED [Part]: SUM([Extended Cost])}

     

    Which would get you:

    I'd probably (not having your real data, so just a guess) two new calculations using LOD (Level of Detail expressions): Max Cost{FIXED [Part] : MAX([Cost])}Total Extended Cost{FIXED [Part]: SUM([Exten

    Remove certain fields thereafter and you'd have:Screenshot 2026-07-23 at 2.35.42 PM.png

     

0/9000