Skip to main content

#Tableau Public36 utenti parlano di questo argomento

I have compiled the number of SQL results for my data analytics project into one excel workbook. How can I have multiple Excel sheets in Tableau but not have connections among them? The tables in each Excel sheet aren't necessarily connected. And do not want them to be connected. 

  

Meanwhile, for each chart, I am connecting this same Excel workbook and establishing a new connection every time. I hope there is a better and simpler way.

#Tableau Public

2 risposte
  1. 2 ott, 11:12

    Thanks. But for most of the Excel sheets, there are no common keys for a union.

0/9000

I have gone in circles Googling and I must be missing something glaringly obvious. I am trying to add a worksheet to my data viz that shows the mean profit % by genre. In my data source I have the budget, revenue, profit dollars, and profit % for each movie (along with the genre).  

 

When I add the pill for the profit % the math just doesn't add up (whether I use AVG or SUM). Do I need to add a total for each genre in my spreadsheet somewhere in order to get the mean profit%? Should I remove the movies that have -100% profit from the spreadsheet> My Mystery and Science Fiction genres show 1000%+ and that should be way off. None of the other genres are correct either. I am new to Tableau. I love the platform but I still clearly struggle with the Excel -> Tableau workflows. Thank you for any help or suggestions! 

 

My Data Viz on Public: 

https://public.tableau.com/views/Movies_17901921237330/Sheet1?:language=en-US&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link

 

 

#Tableau Public

2 risposte
  1. 2 ott, 06:15

    You need to create a calculated field in Tableau to compute the Profit % as follows: SUM([profit]) / SUM([budget]). 

    You should not use the pre-computed value in your data.

0/9000

APAC Command Centre — a business performance dashboard with drill-down views across Product Performance, Customer Cost/Value, and Operations & Shipping, tracking gross profit, margin, and return rate trends.

Spotify Analysis — an end-to-end music streaming analytics build. Raw data cleaned and joined in Alteryx (900K+ play events, dedup, date/boolean standardization, a custom macro), visualized across an Executive Overview and Content Performance dashboard with parameter-driven Top-N views and a custom dark theme.

Would appreciate feedback on:

  • Visual design — readability, contrast, anything that feels off
  • Chart choices — anywhere you'd have visualized something differently
  • Navigation/drill-down flow — intuitive, or confusing anywhere?
  • Anything that reads as unfinished — direct critique welcome

Links below — thanks to anyone who takes a look! 

 

APAC Command Centre -

https://public.tableau.com/app/profile/aviral.trivedi/viz/APACCOMMANDCENTRE/HubOverview

 

 

Spotify Analysis -

https://public.tableau.com/app/profile/aviral.trivedi/viz/Spotify_Analysis_17884476660320/ExecutiveOverview

 

 

#Tableau Public  #Reports & Dashboards  #Tableau Desktop & Web Authoring  #Trailhead Challenges

3 risposte
  1. 30 set, 15:37

    We all start somewhere, and I think this is a good effort at making an interesting and structured dashboard, with your navigation being good, and your main page having a good number of KPIs, so not overloading the user. My points below are mostly based around deciding what the question is that you're trying to answer with each chart, but I think there are a few things wrong with individual elements, that you need to be careful of (especially Top N and the Order of Operations). Below is my (personal opinion) feedback, which you're welcome to ignore, should you so desire, sorry it's long. 

      

    I find trend (line) charts that combine multiple years confusing. Your chart suggests an amazing trajectory of sales, no matter which year(s) you select. It doesn't illustrate that, every January, there is a catastrophic drop in sales (compared to December). In my opinion, your chart doesn't show a trend when you have all years selected, you're comparing "Octobers" (plural) with "Septembers" (and the other months), which is a discrete date comparison and I'd plot as a bar chart. It's only a trend when one year is selected, because then all the months are in sequence, but because you're only showing your users Jan to Dec, you're misleading them into believing that sales just keep going up and up. Your chart omits this line at the end of every year, which feels kind of important:

    We all start somewhere, and I think this is a good effort at making an interesting and structured dashboard, with your navigation being good, and your main page having a good number of KPIs, so not ovFor business dashboards, I would stick to one method of telling the user the values on the chart. On some of your bar charts, you have a y-axis, you label every bar, and you colour the bars according to their height. While colour is a personal/customer preference (I usually keep them grey, and pick out key points with colour), your y-axis, at least, is redundant, because I'm not going to read the exact(ish) value of 5.9m, and then look across to the y-axis to check it also says about 5.9m. Ask yourself what you can remove from any chart and it not lose any information:image.pngOn your discount vs. profit, it's not clear whether you're trying to show a correlation, or an indication of spread. You also have two significant outliers that massively increase the required area of your chart. I would consider categorising the average discount into Low/Medium/High, and then using a box-plot to see whether there was a lot of difference. You'd get much more visual separation, as the outliers would 'disappear' in a measure of spread.image.pngYour filter settings on your Top N by Sales may not be correct. You've got Top 5, but the chart is only showing 1. This generally suggests you haven't accounted for the Order of Operations, where Top N is calculated before Dimension filters, I can't download your workbook to be more specific, though.image.png

     

    On your map, you've highlighted that Mongolia has the lowest sales at $Ā£3.1K, but the mark on the map is NULL (no sales), and if I mouse over Papua New Guinea, it has sales of $1.9K, suggesting that after you've labelled the chart you've changed the filters. Make sure any annotations are correct, because they're pretty static

    image.png

     

    On your Performance per Sub Category chart, I don't know what a red bar and a green bar mean: it's not the size of the bar; if it's the profit margin, you have the number labels displayed as red (which you appear to be using to mean "bad"?), but against green bars (and is a profit margin of 15.3% "bad"? in the industry I'm in we'd bite your hand off for that). Equally, the actual profit from phones and accessories is about the same, so if the message you want to convey is about good versus bad profit margin, I'm not sure this chart makes that point clear. The main message of a chart shouldn't be one of the secondary preattentive attributes of a chart.

    image.pngOn your heat map of delays, your commentary says delays have stayed relatively constant, but you've used a colour range that maximises the visual difference (a min to max colour range). Also, the colour isn't related to the value in the cell, and there's no legend to tell me what it actually is. If you wanted to convey a relatively constant amount, then perhaps a scale that was from an exceptional level (0 days) to a terrible level (10 days?), which would then support your message. Having a target might be more appropriate to show where you've done well. If this was a printed report, the colour bears no relation to the value displayed:image.png

    If I mouse over, I can deduce that it's the record count, but your user isn't told that anywhere. 

    Finally (sorry), on your shipping delay hotspots, you have the same colour meaning multiple different values, becuase you're using a dynamic legend. If you change the year, the dark red means anything between 5 and 7 days, but visually, Pakistan in 2023 (5 days) is as bad as Cambodia in 2025 (7 days), despite Cambodia having 40% longer delays, on average. For this chart, I would use a static range, where anything beyond my target, e.g. 3 days, is red. As it stands, if the business was transformed, and the longest delay was 1 day, that would still be considered "very bad red".

    image.pngMy two top tips would be: always know the question you're answering - if you want to say something is good or bad, you have to define good and bad, and these will often be static values or targets; when you think a chart is finished, look to see what you could remove without losing any information.

0/9000

Hi

 

Has anyone done a viz around Search Engine Optimization. I have pulled through some organic traffic, pages etc from GA into tableau and looking for visualization ideas.

 

Regards

9 risposte
  1. 6 apr 2024, 09:30

    Interesting project! Incorporating visualization into SEO data can offer valuable insights. Have you considered visualizing the impact of <LINK REMOVED BY MODERATOR> improving SEO with CTR increase over time? It could be fascinating to see how different strategies affect click-through rates and overall organic traffic growth.

0/9000

 

Here in this bar chart, i have plotted total admissions against age groups. The admissions is a calculated field derived from female count + male count. Now I want a stacked bar chart with distinct colors for female and male count/percentage. How can I do that?

How to put up a stacked bar chart

 

 

 

#Tableau Public

1 risposta
  1. 29 set, 15:25

    @Shubhangi Jadhav

     you'll want to Pivot your data in the data source tab (1st tab of every workbook). 

     

    Go to the data source tab, select Male/Female columns, then right-click and from the menu of options, select Pivot:

    you'll want to Pivot your data in the data source tab (1st tab of every workbook).From there, you'll then see Tableau represents the data as Pivot Field Names and Pivot Field Values (you can click into the header and rename these):Screenshot 2026-09-29 at 8.20.38 AM.png

     

    Then you can build your view: 

     

    Screenshot 2026-09-29 at 8.22.19 AM.png

    To get the percentage of same, drag another SUM( [Gender Counts] ) as example field.  Then right-click and select Quick Table Calculation, then from sub-menu to that, select Percent of Total.   

     

    Screenshot 2026-09-29 at 8.57.31 AM.png

     

    Then set the compute by to use Table Across:

     

    Screenshot 2026-09-29 at 8.57.58 AM.png

    You'll then have what you've asked for in your post: 

     

    Screenshot 2026-09-29 at 8.58.06 AM.png

    If this response answered your question, please mark it as an Accepted Answer? 

    This way, others searching for similar solutions will find the answer faster in the future.

    Best, Don Wise (Tableau Ambassador)

0/9000

If I open the attached Excel spreadsheet and do this using Tableau Public in Sheet 1, I get an error:

  1. Drag Fertility Rate to the Columns shelf.
  2. Drag Live Expectancy to the Rows shelf.
  3. In the Analysis menu, uncheck Aggregate Measures.
  4. Drag Year to the Pages card.

At this point, I get this error:Bogus error message embarrasses me while teaching

 

This is the error text: 

Unable to complete action 

Internal Error - An unexpected error occurred and the operation could not be completed. 

Error Code: 6EA18A9E 

 

If I drag

Year to Columns first, then drag it from Columns to Pages, it then seems to work. Huh? But it gets worse. I continue on, dragging Population and dropping it on Size in the Marks

card. Same error. 

 

A student happened to notice that going to

Format > Animations and setting Workbook Default to Off

seems to stop these errors. But why? Why am I getting these errors? 

 

It seems like quality control took a nosedive when Tableau forced academic users off of Tableau Desktop and into Tableau Public. It is fragile. 

 

#Tableau Public

1 risposta
  1. 17 set, 03:32

    Hi Aren,

    I tried to reproduce the issue using the attached workbook in Tableau Public.

    I followed the same steps:

    • Fertility Rate → Columns

    • Life Expectancy → Rows

    • Unchecked Aggregate Measures

    • Year → Pages

    • Population → Size

    However, I was unable to reproduce the error. The visualization worked as expected, including the Pages control and Size encoding.

    Based on that, the issue may be related to a specific Tableau Public version, workbook setting, or environment rather than the dataset itself.

    Hope this helps narrow down the cause. 

    Hi Aren,I tried to reproduce the issue using the attached workbook in Tableau Public.

     

     

0/9000

Hi, I've made an account recently for Tableau public and I want to download the desktop version but it will tell me "oops, something went wrong. please try again later." I also notice I am signed in on other pages but it has the sign in option on the download page itself. I cleared my cache to see if that helped but no changes. 

 

Any help would be appreciated. 

 

#Tableau Public

2 risposte
  1. 14 set, 16:29

    @Cal Herman see if you can sign-in to this webpage (upper right-hand corner for signing in) with your Tableau Public account log-in information. https://www.tableau.com/products/public/download you should then see the following options for downloading:see if you can sign-in to this webpage (upper right-hand corner for signing in) with your Tableau Public account log-in information. https://www.tableau.Click on the link that corresponds to your device and OS type.  If that doesn't automatically download from there, you'll see the following option, to then select the device/OS type again for a forced download process:Screenshot 2026-09-14 at 9.29.15 AM.pngIf for some reason this doesn't play out for you, let us know what platform you're using as shown in the above screenshot - we might be able to download and attach the .zip or .dmg installation file and attach it to this thread for you.

     

    If this response answered your question, please mark it as an Accepted Answer? 

    This way, others searching for similar solutions will find the answer faster in the future.

    Best, Don Wise (Tableau Ambassador)

0/9000

I am trying to pick back up a TWB that has one connection, to a simple XLSX file. The file has one sheet named Sheet1. 

 

When I open the TWB by double-clicking on it, I get this error:Error 00BF554A when reopening TWB that has one connection to an XLSX file 

This is what I get when I hit Copy Error Message:

Unable to complete action

One or more connections in this data source need attention:

Error Code: AB9D5A55

Missing connection name in relation

Unable to create extract

I am then sent into file recovery:image.png

I have opened the TWB in a text editor and have confirmed that the connection element shows the correct file path and sheet name. 

 

Through some button presses I cannot reproduce, I was at one point able to see all of my visualizations, and they were populated with data. But if I went to the Data Sources tab, I got a similar error as above. That the visualizations were all populated with data seems to confirm that my data source is good.

 

I am running Tableau Public 2026.2.2 on macOS. The only thing that I have changed since creating this file was upgrading from 2026.2.1 to 2026.2.2. 

 

#Tableau Public

2 risposte
  1. 15 set, 16:46

    I suspect the file recovery dialog was a red herring. It may have referred to some prior workbook that I didn't save properly. We can ignore that. 

     

    The problem is when I get the error mentioned at top, about a data source connection, I don't see how to get into my workbook at all. 

     

    When I X-out that dialog, I get this next:

    I suspect the file recovery dialog was a red herring. It may have referred to some prior workbook that I didn't save properly. We can ignore that.

     

    And there, I immediately see an obvious problem, a reference to e .hyper file. Not only did I never use a .hyper file for this workbook, hyper files are not even supported in Tableau Public! 

     

    If I use the 

    Deactivate the extract option, I get a second dialog with another arcanely-named .hyper file. I deactivate that one, too, and I land on the screent hat invites me to open a file or connect to a data source:image.png

     

    This makes no sense. All I connected to was an Excel data source. I never used a .hyper file. I should not need to deactivate any connections. I should see my workbook, not this screen.

0/9000

Hi everyone,

I’m using Tableau Desktop Public Edition 2026.2.2 on Windows and I’m trying to publish a completed dashboard to Tableau Public.

The problem is:

  •  Under Server, I only see Run Optimizer
  •  I do not see Tableau Public → Save to Tableau Public
  •  The shortcut Ctrl + Shift + S also does nothing 
  • Help → About Tableau Public confirms I’m on Public Edition 2026.2.2
  •  I also encountered this error earlier when trying to publish: 

     

    ā€œUnexpected error: TypeError: Cannot read properties of undefined (reading 'apply')ā€

The workbook itself opens and works normally, and I can save it locally. I’ve also tried restarting Tableau and signing into Tableau Public in the browser.

Has anyone seen this in Public Edition 2026.2.2? Is there another way to trigger publishing, or is this a known bug with the current build?

Any help would be appreciated. Thanks! 

 

#Tableau Public  #Tableau Server

1 risposta
  1. 14 set, 19:28

    Hi @Priya Areti

     

    the option to publish to Tableau Public is not under "Server" but under "File" menu. 

    If you have other funny issues, try to repair or uninstall/install the application.

0/9000

Unable to complete action 

Workbooks saved to Tableau Public must use extracts. To create an extract, click the Data Source tab, then select Create Extract.  

 

The data source, Sheet1 (Tableau_Day_20 _A), is not an extract. 

Error Code: 3C242D89 

 

#Tableau Public

3 risposte
  1. 7 set, 14:18

    Hi, 

    Please take a look at this previous article! 

     

    <past article> 

    https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX00000kSFQE0A4

     

    <Note>

    Also, I’ve recently seen an increasing number of AI-generated answers being posted without sufficient verification. When evaluating suggestions, I would recommend giving particular consideration to answers that include concrete examples or tested samples. 

0/9000