/r/tableau

Photograph via snooOG

Tableau makes software for data analysis and visualization that is easy to use and produces beautiful results. /r/Tableau is a place to share news and tips, show off visualizations, and get feedback and help.

A place to share news and tips, show off visualizations, and get feedback and help.

Community Guidelines

  • If you have a question, make a self post with a link to the workbook in question.
  • If you link to a viz that isn't yours, please link to the original site.
  • Original Content [OC] is encouraged!
  • If you would like feedback on your viz, tag it with [Feedback]

Useful Links

Related subreddits

/r/tableau

79,623 Subscribers

1

Weekly /r/tableau Self Promotion Saturday - (December 14 2024)

Please use this weekly thread to promote content on your own Tableau related websites, YouTube channels and courses.

If you self-promote your content outside of these weekly threads, they will be removed as spam.

Whilst there is value to the community when people share content they have created to help others, it can turn this subreddit into a self-promotion spamfest. To balance this value/balance equation, the mods have created a weekly 'self-promotion' thread, where anyone can freely share/promote their Tableau related content, and other members choose to view it.

0 Comments
2024/12/14
04:01 UTC

2

Monthly Tableau practice?

I am a student currently learning tableau, while I was setting everything up I saw on tableaus website a monthly practice data visualization thing, but since I've gone back to try it, I can't find it.

Would you recommend me doing this if I can find it? or should I pursue other practice data sets and instructional videos on the tableau website?

1 Comment
2024/12/14
03:33 UTC

1

Custom Footers for Financial Package

Hello. I'm looking for a solution and wondering if Tableau could be the answer. I have a financial reporting package created in Excel that I intend to export to PDF to provide to clients. The problem is getting the custom, somewhat complex, footers onto the final product. I've worked with marketing design people and their solutions are too complex or finicky. I'm wondering if we could export the financial reporting package from Tableau with customer footers? Thanks!

3 Comments
2024/12/14
00:07 UTC

1

Is anyone taking Tableau Cloud backups?

Our company is going down the road of exploring the importance of backing up all of our workbooks and data sources from Tableau Cloud. We'd use python scripts to download the content each night and save it on a repository.

I know Tableau will back up the entire pod and restore it if something were to happen to the entire pod itself, but I don't believe they will restore a piece of content if it were to go missing/corrupt.

Is anyone doing cloud backups? Is this overkill?

6 Comments
2024/12/13
18:46 UTC

0

Is there a way to store the result of a running sum?

I currently have a running sum calculated field and I only want the running sum of the start dates. Basically I want to use these values of the running sum for a percentage value in a bar chart. So, instead of having the value be 1/1 for 100% because there is only one person with that effective date, I want it to be 1/8 for 12% since there are 8 people who started during and before 2023.

Is this possible to do or will it have to be done before the data is brought into Tableau? Any help and/or insights would be appreciated.

https://preview.redd.it/15n8ck0i6n6e1.png?width=1915&format=png&auto=webp&s=d5ab2eeb97aa0beb69632a4c58d3969b6519a2cb

https://preview.redd.it/dvrf2e2j6n6e1.png?width=1917&format=png&auto=webp&s=224c38e8e54bed03962728d41f1c899f92daa990

https://preview.redd.it/d2rkdjuj6n6e1.png?width=1917&format=png&auto=webp&s=3879765cc3c8e8c6f941182653cbf8380bce478c

3 Comments
2024/12/13
16:28 UTC

0

Viz in Tooltip help!

Hi All,

I'm building a dashboard for work and have used a filtered Viz in Tooltip for all charts within a workbook to make it consistent and easier to maintain moving forwards.

What I've noticed when published to the server is that every so often the filter applied to the Tooltip viz will be incorrect for the dimension value I'm hovering ob over but only typically for one data point of the dimension. If I change dashboards within the workbook and return or change an unrelated parameter it will then show the value as expected.

Has anyone encountered this? I can't replicate this on my desktop and I'm tearing my hair out!

2 Comments
2024/12/13
12:57 UTC

5

You can trial Tableau Agent for free now

Tableau Agent is now part of the free Tableau Cloud trials.

https://www.tableau.com/products/tableau-agent

0 Comments
2024/12/13
01:41 UTC

2

Table 1 and table 2 not joining column correctly?

I have a table 1 and table 2, each has a key field that is the same field between them with relationship set for key = key between the tables. When I have a very basic viz with a filter set to display just 1 key in table 1 (say key is "ticket-10") and then attempt to use key from table 2 by dropping "key (table2)" in the row column, the entire viz disappears. I would figure the proper behavior would join based on key and look for "ticket-10" in table 2 and then display that key. When I go to the analysis drop-down menu and click "show empty rows" it makes the table2 key appear but with the value "Null" as if it can't match it. The key values are the exact same (ticket-10 in this case). Why is it showing them as not being related at all/not finding the relationship between them?

5 Comments
2024/12/13
00:11 UTC

1

Rank of running Sum week to week

Im running a set of Formula 1 data and trying to rank each driver after each race. I have calculated the the running sum from race to race but can’t figure out how to rank the drivers amongst each other in order to see how the progress through out the year. After a few hours at this I am in need of help.

Thanks in advance !

6 Comments
2024/12/12
18:03 UTC

2

Is Tableau the right tool?

I am having trouble coming up with a solution and was curious if Tableau would be a platform for creating a solution?

I manage a home health service with about 40 nurses and 1000 patients across the state.

I’m trying to create/find a solution that will ensure that my patients are being seen by one of the nurses geographically closest to them.

The nurses case manage and see patients long term so I need to evaluate current locations mapped to nurses and then ongoing.

Thanks for any nudges!!

11 Comments
2024/12/12
17:57 UTC

1

How to Include All Marks in a Tooltip for One Location on a Tableau Map?

Hi Tableau Gurus! I am a Tableau newbie (which may be obvious in this question) and am running into an issue with mapping. I want to make a map that displays all of the technical areas my organization works in by country, but the tool tip is only showing information from one mark, not all of them. For example only showing Country: South Africa | Technical Area: technical area 1 rather than Country: South Africa | Technical Area: technical area 1, technical area 2, technical area 3

Right now the best solution I’ve come up with is to do viz in tool tip, but it seems like there should be an easier way to do this?

Has anyone faced this issue and found a good workaround? I'd really appreciate any tips or tricks. Thanks in advance!

1 Comment
2024/12/12
17:43 UTC

2

Need to conditional format cells based off under or over hours

Hello , Tableau community I need to display estimated hours of work versus actual hours on multiple jobs we have in progress . I was thinking just have some sort of conditional format where I subtract the actual from the estimated and if its negative mark it green and if its positive(over hours) mark it red. I tried calculated fields but i can only apply one function to the color marker, but there are multiple columns we are tracking estimated versus actual . I tried to do total variance of the entire rows of all actual versus estimated but that didn't work either. Kind of hitting a wall here. Then after it works I need to make it "cool" lol...

5 Comments
2024/12/12
16:06 UTC

1

DATEDIFF

Hello Everyone

I am looking for some assistance. I am needing to calculate the number of days between a start date and a date resolved.

I can create the DATEDIFF calculated field to show this, however I am also wanting to show the number of days passed if the issue doesn’t have a resolved date in the same column.

Would it be an IF statement?

Thank you for any and all suggestions! This sub is always very helpful.

5 Comments
2024/12/12
14:08 UTC

15

Tableau to PowerBi

I have extensive experience with Tableau products, including desktop, server administration, and migrating on-premises systems to Tableau Cloud using Bridge. I haven’t used Power BI yet. Considering the current job market, is it better to learn powerBI?

27 Comments
2024/12/12
00:50 UTC

1

Tableau help

Is there any tutors to be used for tableau anyone has used? Need help with a few things. Thank you

4 Comments
2024/12/11
19:02 UTC

1

Tableau Desktopo just won't show all my data points from a single connected table!

Edit: I found out Tableau only shows exactly every other row! but whyyy :'(

Please, I am losing it over this issue. I connected a MariaDB hosted on AWS to Tableau and used just a single table as my data source. In it is just a list of products and their variants (eg table in white, red, blue). Tableau just won't show me all the entries of the database! I want all the IDs (1, 2, 3, 4, 5, etc), there are no filters anywhere (not in the viz nor in the source)

https://preview.redd.it/dqyh6hr4j96e1.jpg?width=199&format=pjpg&auto=webp&s=35779fdeda3efb8823f195b951b5e585f23a172b

I have tried giving it a customized SQL query but same problem!

The entries in the data base DO EXIST, if I use HeidiSQL (data base tool) and use the exact same query all the entries pop up!

Did anyone here ever experience this? I have no idea what else to do, I disconnected then reconnected the DB, cleared my cache, there are NO filters at all anywhere, why won't it give me my data? :'(

12 Comments
2024/12/11
18:35 UTC

2

Is it possible to use a chart as both a filter and a toggle switch for a parameter? Parameter action not updating parameter.

Hello!

I am trying to create a feature on a market dashboard where if someone selects a bubble from a bubble chart, the dashboard drills down into that specific market but also changes one sheet displaying from a table to a line chart.

I have been able to get the parameter to correctly toggle between displaying a table and a line chart, but only through changing through the drop down parameter menu.

Is it possible for selecting a bubble in the bubble chart to filter down to that specific market but also change whether the table is displayed or the line chart is displayed?

Ideally, when nothing is selected in the bubble, I would like the table to be displayed, but when a bubble is selected the line chart.

Thank you for any insight or assistance with this! Just getting started out.

4 Comments
2024/12/11
18:18 UTC

1

Filter True/False Disappears once more than one measures are added.

The first picture below has one measure, two dimensions, and one filter. The filter gives an option of True/False. As i add a second measure, the filter box gets added a filter called "measure names". The issue is that my True/False for my first filter "250 Market Share Metrics Filter" disappears. Anyone know why?

Picture 1 Above

Picture 2 Above

1 Comment
2024/12/11
17:37 UTC

0

Display values per question AND category on aggregate level.

Hi all

https://preview.redd.it/i6zw5i8jl86e1.png?width=928&format=png&auto=webp&s=c51683531db785fca1deb1c1fe865977682233b4

I'm almost where I want to be with my visualisation of likert-scale data from a survey.
There are 87 questions, grouped into 24 categories. I'm displaying the result of each question at the moment, but would like to add the average score per category. I managed to doi this, but the score is displayed per question and not per category, so there are a lot of duplicates. Is there a way to display the average score for the category only once?

Also, the average score per category is now added as a separate chart. To align the values to the left side of the axis, I just adjusted the axis to go from 1 to 200. However, I would prefer to do this a bit more 'cleanly'. The target result would be a square/circle/shape, centered per category. And, I'd like to be able to 'crop' the right chart so it is smaller than the one displaying the results per question, as this is more important information. I haven't yet found a way to do this, without also making the left chart smaller. I don't want them to have equal sizes, but they seem to be 'glued' together...

can anyone tell me how this is done?

Thank you!

3 Comments
2024/12/11
15:19 UTC

0

Fabric with Tableau?

Can Tableau Cloud work with Microsoft Fabric? That is, can Tableau Desktop function if the data it connects to must live inside Fabric? I want to avoid having to switch to Power BI.

1 Comment
2024/12/11
12:05 UTC

1

Help with a visualization

In my job i’m facing a issue with a visualization:

I have 2 tables, one has customer count and the other has the number of accounts written off. Both the tables have date columns but one is in string format and the other as a measure. They have a column which can be used to make the join, which is company code column. I am doing this in tableau

The data, i pulled it from bigquery. The metric i have to show is number of accounts written off from the customer base. The comparison i have to show is WOW, MOM and YOY.

Do i have to join on the date, to show this comparison visualization?

2 Comments
2024/12/11
00:55 UTC

3

Tableau and Storytelling With Data

I’m working on learning Tableau and recently read Storytelling With Data by Cole Knaflic. The book provides clear examples for creating effective visualizations for your target audience. The book makes the distinction between exploratory analysis and explanatory analysis. One of the key takeaways was that explanatory analysis should be presented to the audience in a storytelling fashion. I can see this type of presentation coming into play when you are creating a PowerPoint to communicate your findings to an audience.

My questions primarily relate to how I can apply lessons from the book towards Tableau. In my mind dashboards focus in on a particular set of data, but enable exploratory analysis by leveraging filters to allow the user to explore and visualize the data for themselves. Is this an incorrect line of thinking? Should dashboards be more explanatory the exploratory?

For dashboards that you use for your portfolio should they “tell a story”? How do you tell the story to an audience who may be going to your portfolio from a resume? Instead of telling a story in a portfolio dashboard, should I focus on accurately representing data from the dataset a company may use as part of their KPIs (Change in sales last quarter, average customer satisfaction, etc.)? How do the dashboards you build for a portfolio differ in comparison to those you’d build on an average day at work?

2 Comments
2024/12/10
21:39 UTC

0

Help! Tableau Error 3834d197 When Refreshing Dashboard Linked to Google Sheets

Hi everyone,

I’m running into Tableau Error 3834d197 and could really use some help. I’ve been working on a dashboard that pulls data from a Google Sheet. It works fine initially, but as soon as I make any changes to the Google Sheet and refresh the dashboard, this error pops up.

I’ve already updated Tableau to the latest version, but the problem persists. Does anyone know how to fix this or what might be causing it?

Thanks in advance for your help! 😊

5 Comments
2024/12/10
21:17 UTC

2

Solved: Tableau Server CSV/TSV export issue

I just solved this for myself and figured I would share.

The Problem

Tableau server's native export says that it exports as a CSV, but in every instance I've looked at, it was always actually exporting as a Tab Separated Value (TSV) but still disguised as a .csv. To check this just open your exports in TextEdit.

This was causing my users issues when uploading to different platforms, especially when there was a comma in a value contained in the export.

The Solution

I couldn't for the life of me find an existing plugin that forced a CSV export so I wrote an open source one for anyone to use/fork.

https://github.com/gmfennema/Tableau-Force-CSV-Export

Hope it helps!

0 Comments
2024/12/10
20:14 UTC

2

How to embed single graphs?

On this webpage https://www.eea.europa.eu/en/analysis/publications/sustainability-of-europes-mobility-systems/passenger-transport-activity

They use Tableau to create graphs and then embed single interactive graphs on a website. How can you do this? Is it the same way as embedding a full dashboard?

4 Comments
2024/12/10
19:03 UTC

1

Filters

I have a worksheet that is published (not a dashboard) that has two rows of filters across the top. For some reason the second row doesn't center.

I would like the second row filters to expand to fill the same space horizontally that the first row fills if that makes sense.

On another sheet, I have just one filter in the second row and it expanded further out than the first row.

How can I adjust this?

0 Comments
2024/12/10
14:11 UTC

2

Starting out

Hello all Tableau users and lurkers,

I recently had to completely a small little project using tableau and I began laughing to myself because it I was enjoying it. I was hoping for any good resources that could be used in order to better understand and just learn it honestly. Preferably free! Thank you to anyone who answers this message sending internet hug!

8 Comments
2024/12/10
16:58 UTC

1

Splash Page Adjustments?

Is there any way to change this page? I literally never need the quick start section. At all. Ever. Not a single time.

But I sure would love to double the number of recent workbooks at the top. Anyone know how to change that? Is it possible?

If not... come on, Tableau... let us personalize things a LITTLE bit...

Stuff blocked out intentionally. You know. Because rules and stuff.

0 Comments
2024/12/10
15:56 UTC

2

Tableau prep cli issue.

Hi guys

I have been trying to setup tableau prep clibut keep running into an issue with the message “This connection is not valid” even though i have checked my credentials.json file multiple times and also entered same creds on site to ensure i am entering the correct pwd and username.

What can i do here please advice

0 Comments
2024/12/10
12:59 UTC

Back To Top