I have column_A and it is a multi-select picklist column where it could have values like A, AB, ABC, AC, and so on. I want to get all distinct values and count their frequencies so I should get something like A=4, B=2, C=2, and so on.

For this, I have calculated fields written for every distinct value such as A = IF CONTAINS([column_A], “A”) THEN 1 ELSE 0 END, B = IF CONTAINS([column_A], ”B”) THEN 1 ELSE 0 END, and so on.

I have all distinct values in column_A in one worksheet.

In worksheet #2, I have column_B, which is also a multi-select picklist column and calculated fields are written similar to above formulas. And lastly, I have another worksheet #3 and I‘m working with column_C here, which is also a multi-select picklist column.

I have all these worksheets in dashboard A with filter actions. BUT I can only use worksheet #1 to filter worksheet #2 and #3. I can’t use worksheet #2 and #3 to filter each other and worksheet #1. Why is that? Is there another way to do what I want to do here? Thanks!

When I go to tableau.com/academic/students service offers to use Tableau Desktop Public Edition, which is free.

While previously it seemed that students could get 1 year of Desktop for free by confirming their status. Is there no such option now?

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.

Howdy Y’all,

I made a personal budget dashboard that allows users to enter their own information and see their debt to income with running totals.

I am open to critique, but mostly wanted to share in case it’s actually useful to someone else.

https://public.tableau.com/app/profile/josh.may/vizzes

Hello all, first post here.

I’m currently a level 1 tableau admin and we have been tasked with creating an in depth admin dashboard to monitor the performance of certain dashboards in our environments.

This has mainly been caused due to tableau sessions going into a delayed state in teradata causing bad performance.

Does anyone have any examples of how they have setup some admin dashboards to get in depth analysis.

I have 0 developer experience so any help is appreciated. Just looking for ideas.

Thanks!

This post will separate the casuals from the pros.

I work for a BIG company, and our reporting is open up to most area-aligned employees (10k or so).

This place has LDAP groups setup for its user-profiles, and we create workbook-specific LDAP groups to help manage this access in bulk (users assigned to LDAP, LDAP assigned to dashboard).

We’re talking user-filters/row-level security to completely restrict certain groups from viewing displays outside of their group’s function.

Of course you could duplicate a workbook and restrict access to a group that way, but with this set-up, what would you recommend for implementing and managing row-level security permissions? New LDAP groups for these groups?

TIA.

Hey Yall,

working on a pretty decent visual. Since my data is quite unique to my organization, the most simple way I can explains my map is kind of by saying: I plotted Starbucks as “large dots” in various regions, I overlayed customers who enjoy coffee as secondary dots on the map.

Trying to identify customers within 50 miles, Is there a way to size the radius of my “Starbucks circle” based on 50 miles? I’d like to see the radius in reality when looking at a specific region.

I know we can calculate distance between dots, but is there a way to size the radius of a specific dot on my map?

Let me know if that makes sense. Thanks!

Is there a way to connect a tableau dashboard to a pdf document? The document just has text data, no tables. Also, I have a new pdf document in my folder every week. Is there a way to automate the dashboard to pick the latest document ?

https://preview.redd.it/164ih9xhi7ge1.png?width=288&format=png&auto=webp&s=1f1393250edf1554584a4de96ac3735eafbd4890

I want to maximise the space on my dashboard but can't move anything past the dotted line. Most of my containers on the dashboard have this "leftover" space. I can get rid of it with 'distribute contents' but I need the charts to be different sizes.

I'm working on a Tableau dashboard where I have a scatter plot and a text table listing different policies. Each policy has categorical values like "Trump Support", "Mass Shooting", "Academic Support", and "Law Enforcement Support", which can either be "Yes" or "No".

What I Need to Achieve:

1. Color Coding: I want the text boxes in the policy table to be:
2. 🟠 Orange if any of the categories have a "Yes" value.
3. 🔵 Blue if all values are "No".
4. Interactive Highlighting:
5. When I hover over a policy name, I want the corresponding data point in the scatter plot to be highlighted.Ideally, I'd like the scatter plot points to filter or emphasize only the relevant ones based on the hovered policy.

What I've Tried:

• I created a calculated field for color coding

​

IF [Trump Support] = "Yes" OR [Mass Shooting] = "Yes"      OR [Academic Support] = "Yes" OR [Law Enforcement Support] = "Yes"   THEN "Orange"   ELSE "Blue"   END 

• Applied this field to the Color shelf in the text table.
• Added a Highlight Action in the Dashboard but it’s not working as expected (not consistently highlighting the scatter plot points).

Questions:

1. Is there a better way to ensure all relevant scatter plot points are highlighted when hovering over the text table?
2. Can I make the highlight persist until I hover over another row instead of disappearing immediately?
3. Should I use a Filter Action instead of a Highlight Action for better interaction?

Would really appreciate any guidance! Thanks in advance. 😊

I have been using Tableau since Tableau 7 in 2012. Our team used to attend the conferences every year. We are moving away from Tableau and using PowerBI for dashboarding. We are a fortune 100 company.

I don't build dashboards, I use tableau prep and the capabilities to pull in large amounts of data and join them together for analysis. I make a lot of crosstabs, impact calcs, and trend views to find outliers and investigate data. I am 'jedi' level and can LOD with the best of them.

I have used Power-bi in the past and have found it much more cumbersome to do analytics. While powerbi is great for static dashboards, it feels cumbersome for what I do.

What kind of justification can I make? I don't require a Tableau server, just a stand-alone license.

I have an opportunity to do some consulting work, but I realized there's quite a bit I don't know about the billing side.

For those who have done their own thing, can you please brief me on how you handle this? Do you charge by the hour, and give them an LOE? Flat fee for each project? Do you have like an itemized invoice? Build in a dev fee and also a monthly (or however often is appropriate) maintenance fee? Did you setup an LLC?

Thanks in advance!

Hi All,

Want to know how we can maintain versions of tableau in azure repo and also if we can deploy through ci/cd from repo to server.

I want to modify the layout of a line chart in Tableau.

I'm a beginner studying Tableau, and I'm trying to replicate someone else's public work. However, I'm stuck on two things:

1. I want the column title to be displayed at the bottom, but I don’t know how to do it.
2. I want to minimize the number of displayed column labels (only the labels, without affecting the charted data).

https://preview.redd.it/crzlxaj8o3ge1.png?width=1362&format=png&auto=webp&s=34d6d9f5e9a6dbf11e3aae1cf8f49adad5fb0dbf

The result I want to achieve looks like this:

https://preview.redd.it/yl8o4i8ao3ge1.png?width=521&format=png&auto=webp&s=60bf2033424476e26a7baf2cf5ac637ab4f5ce04

I've searched on YouTube but couldn't find a solution.

Could anyone help me out?

I have tableau flow on my tableau cloud account. The output for this flow is currently a live connection. How do I convert it to an extract?

I have a table where years are stored as strings (e.g., "2022", "2023", "2024") and quarters are also stored as strings in another column (e.g., "Q1", "Q2", "Q3", "Q4").

I need to create a KPI that calculates the percentage difference between the most recent available quarter and the previous quarter.

https://preview.redd.it/ry70l3jw61ge1.png?width=144&format=png&auto=webp&s=09ffa9eb9508c463b186c36775bc4c51e6bed0cf

However, when I create a table calculation and filter to show only the last quarter, the calculation does not work and returns a blank value. It only appears when I include both the last two quarters in the visualization.

How can I display only this last percentage value while ensuring the calculation still works?

I spent weeks studying for my second Tableau Desktop specialist exam and I failed again. I took practice exams, an online course, and referred to the official site constantly. I'm an anxious test taker so I made sure to get plenty of sleep and try to relax and yet nothing. I have my third exam scheduled on valentine's and I thought I should come here and hopefully get some advice from people who have passed so if you have any, I'm desperate.

I’m trying to get the value that is shown just before the arrow into either of the two Test fields. STAGE_LOCATION and Stage Location are on two separate tables. I need the value from the Stage Location to be null, and the value on STAGE_LOCATION to be A. I created the Null Stage Location to try and force a left join, but no matter what I try, I can’t get the value to populate in either Test Column. So I’m reaching out for help.

I’m curious if anybody’s companies have had luck offloading extra Tableau work to part-time or contract developers. High-level from looking at websites like Fiverr it doesn’t seem like the sample work is very advanced.

Has anyone successfully brought in part-time Tableau help? If so:

• How did you find them? (Freelance platforms, word of mouth, etc.)
• What types of work did you offload? (Dashboard building, data prep, maintenance, etc.)
• Was it worth it in terms of cost vs. quality?

Would love to hear any experiences!

I have a table with several columns:

What I want to do is count the distinct ADMIT_KEYS across MEASURE, DISCH_DATE, PLAN, and LOB without that value being impacted by FU_TYPE. (There other FU columns afterwards, I want to ignore those too but I'm just trying to simplify this example.)

Essentially I am trying to get a count of discharges from the hospital over those 4 columns I listed above. Then, there is a bunch of data about follow up appointments that all start with FU. So the first Admit Key 673651161 - that person was discharged on 1/2 and had six follow up appointments. So for this visual, I need to always know the number of distinct discharges but still allow users to play with the various FU filters to get what they want.

So far I have tried to use {FIXED MEASURE, DISCH_DATE, PLAN, LOB: COUNTD(ADMIT_KEY)} but the count that I get is still being impacted when the FU_CATEGORY filter is changed. I have tried adding the fixed columns to Context but that also does nothing.

So in the example below, no matter what the user changes the filter to for FU category, I want to see 14 discharges for Measure1, Jan 2023, Plan1, XYZ Line of Bus. But when I use any variation of that FIXED formula above, the count changes from 14.

I feel like I am doing something to make this more difficult than it needs to be.

https://preview.redd.it/03fqoctsyzfe1.png?width=539&format=png&auto=webp&s=a969d2a1f779bcacc4f929072b27617487b3f15a

I’ve been looking all day and am ultimately unsure if I’m just stupid or what, but I have an extremely simple task that I cannot for the life of me figure out. I unfortunately work on a different system and can’t post screenshots but will try to explain as best I can!

Okay so I have two different data sources. I am simply trying to divide part of a field in one by part of a field in the other.

For example, one field is named ‘Tasks’ and within ‘Tasks’ there are individual offices within it. One office is graphics, and Tableau shows 97 tasks for graphics office. The secondary data source only contains static numbers containing amount of employees for that office.

I am literally only trying to divide the 97 tasks number by the 10 employees in graphics and I am at my wits end with it.

I can’t do a simple DIV calc field because they aren’t integers. I can’t divide the field by just the number 10.

If it comes down to it, I don’t even need the second data source if it would be easier for me to just plug in the employee numbers for each office manually.

Can anyone save my last remaining brain cell before I bash my head off the desk and kill it?

Whenever I am trying to Add new excel file tableau public is giving me this

Unable to complete action

There was a problem connecting to the data source "Untitled Data Source".

Error Code: AC0843EA

Could not start Hyper: Failed to start a new Hyper instance.

Context: 0x86a93465

Caused by:

The Hyper server process exited during startup with exit code: 1

Command-line: ""C:\\Users\\BRISHTI\\AppData\\Local\\bin\\hyper\\hyperd.exe" "run" "--crash-dump-path=C:\\Users\\BRISHTI\\Documents\\My Tableau Repository\\crashdumps" "--date-style=MDY" "--date-style-lenient=false" "--fallback-on-unknown-locale=en\_US" "--init-user=tableau\_internal\_user" "--language=en\_US" "--log-config=file,json,all,hyperd,0" "--log-dir=C:\\Users\\BRISHTI\\Documents\\My Tableau Repository" "--log-file-backup-size-limit=1m" "--no-password=false" "--skip-license=true" "--storage-providers={\\"providers\\":\[{\\"type\\":\\"single-file\\",\\"name\\":\\"single\_file\\",\\"allowed-directories\\":\\"all\\",\\"default-directory\\":\\"C:\\\\Users\\\\BRISHTI\\\\AppData\\\\Local\\\\Temp\\\\TableauTemp\\\\hyper\_17496\_1avts891e4ox9t160yksn0mmai5c\\"},{\\"type\\":\\"transient-file\\",\\"name\\":\\"transient\\",\\"entry-lifetime\\":\\"0ms\\",\\"entry-limit\\":0,\\"size-limit\\":\\"0\\",\\"temp-directory\\":\\"C:\\\\Users\\\\BRISHTI\\\\AppData\\\\Local\\\\Temp\\\\TableauTemp\\\\hyper\_17496\_1avts891e4ox9t160yksn0mmai5c\\"}\],\\"default\\":\\"single\_file\\",\\"default-transient\\":\\"transient\\"}" "--listen-connection" "tab.pipe://./pipe/auto" "--callback-connection" "tab.pipe://./pipe/{75BD48F3-1232-4899-A418-A7C3DCD25ECB}" "

Child process' stderr:

Unable to open log file: CreateFileW("\\\\\\\\?\\\\C:\\\\Users\\\\BRISHTI\\\\Documents\\\\My Tableau Repository\\\\hyperd.log"): The system cannot find the path specified.

FileListener in error state after initial rotate()





Check the hyperd log for more information

Context: 0x13cead20>!​!<

I have a csv file that contains semicolons in some of the columns. However the moment I import that file into Tableau it gets split by those semicolons. Is there any way to prevent this behavior?

Hi all, first of all a bit of context. I’m currently doing a trainee in Finance and Business Intelligence and now I have the opportunity to stay for other 6 months until the start of my master in probably Sustainable Finance. I’m mentioning this because maybe it helps you to give me your opinion.

Now, I’m not happy with the salary they offered me. I tried to negiotiate but there is no chance on changing that. Consequently I’m thinking of looking for something else.

Now to the question related to this sub. I’m usually very hungry to learn, especially if it can benefit my career development. The company I’m in, is going to start with tableau as of next month (we just used salesforce until now. What I’d like to know is how beneficial this tool might be for my career. You know, ultimately, if it’s worth the low salary (I care about the money in this case because I’m saving for my master).

I know it’s very broad, but any kind of insight will be of value to me. Thank you!

https://preview.redd.it/6o3xdz6hgyfe1.png?width=1919&format=png&auto=webp&s=32f2318ce5f9a8d1cc1927562b40ca867b81f624

Can you help me figuring out what is wrong with my tableau operations? Now values are showing for every file.

I am considering using AWS Athena for Tableau integration. Data would be partitioned into year/month/day/hour partitions.

Using incremental refresh based on timestamp data field, will Tableau generate a query that includes partitioning filters? Or will it have to scan all of the files?

I’m newer to using Tableau. I’ve imported an excel file that has 2 fields: zip and a value associated. I have those added to the map with a color scale but want to have the state borders clearly outlined overtop to make it clearer. Is there an easy way to do that?