/r/tableau
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.
Community Guidelines
Useful Links
Related subreddits
/r/tableau
I have multi-dashboard workbook and for each dashboard I have created a navigation button but by default navigation bar is there in the tableau server. How can I hide the default navigation bar and use my custom buttons for navigation?
Hey I’m trying to make a mosaic on tableau based on an image I uploaded data on. I have all the colors and I’m making progress - is anyone available to chat about it? I’ll explain more in dm or in comments
In my Tableau Desktop app, I'm unable to find options to copy, paste, or even import the workbook containing my dashboards, despite having saved them locally. Can anyone assist me with this issue? Is this feature now limited to paid versions of Tableau?
I have data from a multiple choice question as several data sets. The multiple choice question had 14 different possible answers and so I received 14 data sets as data exports.
e.g. Which smart home application do you use?
Data set 1: 12x lighting / 2x no
Data set 2: 10x heating / 4x no
Data set 3: 5x smart plugs / 9x no
an so on...
I am not able to link them functionally on a worksheet. How do I have to edit / link this data beforehand in order to be able to use it on a worksheet?
Many thanks in advance!
Hello! I am new to using Tableau (as I just learned this yesterday). I am working on an example wherein it uses dateparse to combine a column of date and year.
In the calculated field, I put:
DATEPARSE("MMMMyyyy", [month]+[year])
I was expecting to have something like that in the picture, but I received an empty column. No nulls or anything. I double-checked the data type and both columns (month and year) are strings.
How should I proceed with this?
EDIT: typo on Dateparse. Can't edit the title tho
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.
Is it possible to add a user without a Tableau license to a scheduled PDF view email subscriptions?
Thanks in advance!
Hello everyone,
is it possible to customize the appearance of the webservers provided login page for different URLs in a single tableau server instance? For example, if I have the DNS Entry of customer1.tableau.de and this customer enters the login page using this subdomain, is it possible to provide an individual logo or appearance in general? Or would you need a completely new server instance?
I know that through using tsm commands, you can pretty easily customize the login page in general for the whole server, but I'm not sure whether its possible for multiple "sites" or customers
Hi guys, I've run into a problem after updating my data source and please need your help on how to resolve the below issue.
I've connected to SQL server data source and have around 5 tables connected to tableau from the same database and yesterday I've added a new table and gave the appropriate relationship and published the data source.
The new table is reflecting in my workbook and all the columns with values can be seen, however when I drag and drop any dimension or measure to the worksheet it is blank and not showing anything.
Please help me on how to resolve this issue.
Hi Everyone, I have these two types of table in dwh.
Now i have to merge the table and load into the tableau.
My requirements are 1.Filter for type of result as national, internal result and australia result. 2. Filter as data type as count and percentage If you click on national or internal result only shows percentage filter. If you click on australia result in count and percentage option. So if you click on count then shows diabetes value and if you click on percentage then shows (sum of diabetes/ sum of assessed for diabetes)*100 Any help would be highly appreciated. Thanks
I'm working on a troubleshooting process and want to give my users the ability to easily go to an Excel worksheet on a shared drive. Links to shared drives are not supported in Tableau, so I put the text in a text object, but it seems you can't copy from a text object in Tableau Cloud. Is there a way to make a text object copiable?
Hey!
I am using Tableau Cloud to build my viz.
I have three Measures that are formatted to be Currency numbers. I am attempting to create a blended axis between them. I am following the steps listed in this article.
When I drag my second measure from the Row to the axis, it does not show the double green bars as shown in the instructions. This makes me wonder if this is a limitation of Tableau Cloud. Is this possible using Tableau Cloud?
I have an Employee Info table that contains, among other things, these two fields: HIRE_DATE and TERMINATION_DATE.
What I am trying to do, either in Tableau Prep or Tableau Desktop, is create a field that contains, for each date between the first HIRE_DATE on the table and today, a count of active employees.
As I understand it, I should be able to calculate for a given date if an employee's HIRE_DATE is before that date, if their TERMINATION_DATE is after that date, or if their TERMINATION_DATE is null (meaning they have not been terminated), and sum up the number of employees who match that criteria. If this means that I also need to create a field that is just a list of all dates from the first HIRE_DATE to today, I can do that.
However, I am having an extremely hard time figuring out the calculated field(s) necessary to make this work.
Has anyone done anything like this, or have advice on how to accomplish this?
ETA: Not sure if I used the right flair. Sorry about that.
I have a very basic question. Please excuse me. Why do we use parameters as filters instead of just using dimensions as show as filters?
Hi everyone,
I have a count table in Tableau for the last 4 weeks, and I’m tracking the number of clients. I can see changes in the client count from week to week, but I want to identify which clients by name are causing these changes. Specifically, I want to know which advertisers are new and which ones are lost each week.
How can I achieve this in Tableau? Any help is greatly appreciated.
I’m graduating next May and looking to start a career in Business Analytics. Would you recommend the Tableau Desktop Certification? Has it helped you professionally?
I appreciate your time and insights!
Hi - I need help computing the average number of days between each visit.
The datasource I am working with is very similar to Superstore Sales but let's say instead of states - I have a restaurant dimension field, i.e. the dataset has order datetime, customer id, restaurant id, order value. The granularity is at the payment_id level.
Let's say a customer visits the same restaurant at t_1, t_2, t_3, t_4, t_5, t_6 and let the redemption visit be t_r
How can I compute the avg number of days between each visit?
i.e. (t_2 - t_1) + (t_3 - t_2) + (t_4 - t_3) + (t_5 - t_4) + (t_6 - t_5) / 5 - at a customer_id level
The goal is to see if days between each visit reduced per customer after signing up for a loyalty program.
Hi everyone,
In my company, we used to work on tableau server version 2022 which was working well for our ~180 users daily. But with the increase of data some datasource extracts started taking more and more time, we decided to switch to 2024.x to use incremental refresh, a month ago. since we did this we started having the known Disk Space Growth problem, with the 100% CPU usage too.
The last version that was available since 22 november says that is resolved both of these issues, but it seems that it did not for the cpu problem.
Disk space seems fine now, but the cpu usage still gets to 100% and tableau becomes unusable because of this. restarting the server is not a solution because it keeps happening anyway, and users cannot access their reportings...
Yesterday for example, we had CPU usage at 100% between 2pm and 3:30pm, where no one could use tableau. restarting the server takes around 30minutes.
This morning the same is happening again.
The support is completely useless, we have been working with them for a month now, they answer extremely slowly, and with no solutions. I think it even got worse since we started working with them, because this cpu problem started after the support asked us to modify some of the server settings to fix the disk space problem...
Do you guys also have these problems? did you manage to find a solution?
Because of this CPU problems we may have to rollback to the 2022 version.
Thank you
Hi everyone,
I’m working on an academic project where I need to conduct a Knox test (a spatial-temporal analysis for clustering). However, I’m running into some challenges and could use some guidance.
After searching online all day, I could not find any articles or guides on conducting a Knox test on Tableau, this is why I am allowing myself to post here.
First off I would like to know if the Knox test is doable on Tableau alone, or if I need any other input from R or similare software.
My data includes location coordinates (latitude and longitude), timestamps, and event types as well as additional informational variables.
Any help is much appreciated. Thanks in advance!
I am trying to hide the baseline column. Any quick thoughts? Right click and hide does not work as if i switch to 2022, the data i get appears to show 2021.
Can anyone recommend a make over Monday tutorial? I’m struggling with completing a make over Monday that doesn’t end up worse than the original. I’m looking for a tutorial that also talks you through the decisions made as you go.
Anyone have a good resource for that?
Hello!
I'm new to Tableau and can't manage to make a calculated field work for my intended analysis. I have a BigQuery dataset as the data source with one row per user_id and task_id that reflect players completing the FTUE of a mobile game. Players who haven't completed a single task are featured in the dataset once with their user_id and a null task_id. Each row also contains information about the player such as their country of origin and the date they first logged in. I want to calculate the completion rate for each task_id out of the total playerbase, while being able to filter on country and first_login.
The following calculated fields work (tested) :
The problem seems to be that adding first_login (a date field), as such COUNT([user_id])/SUM({FIXED[country], [first_login]: COUNTD([user_id])}), outputs the wrong percentages in any context. Adding first_login as a context filter also doesn't work.
How can I fix this?
I feel like i'm pretty close (I don't care to do the arrows). I'm just having a really difficult time aligning the metrics names associated with a positive percentage on the left side of the 0% line. My Percentage diff are synchronized and dual axis. I have two calculated fields that are applied to the label of either one of the Percentage Diff Sort Marks cards:
// Metric (left)
IF [Percentage Diff Sort] < 0 THEN ATTR([Metric Name]) ELSE NULL
END
//Metric (Right)
IF [Percentage Diff Sort] > 0 THEN ATTR([Metric Name]) ELSE NULL
END
I've tried formatting the Metric (right) label to be aligned to the left but it aligns it to the right of the 0% line (as you can see in the screenshot), Overlapping it with the bars.
Does anyone know how to accomplish this? Thanks in advance!
I am trying to plot data from two csv files located in different location. I have a file a1.csv in one location and file b1.csv in another location. Both a1.csv and b1.csv have the same column headers. I want to plot the data from these two files together. How do I achieve this? So far the only way i can do that is copy the two files in same location, and create a union that includes the two files. I would like to know if there is a different way.
Good morning group, hope all are well. I need some help please.
I have create date field that i converted to display local time (PST). I need to create filters that will exclude weekends and anything that was create before 8 am and 5 pm. In addition i am trying to calculate the amount of time it spends in a status (if something was created on friday at 4 pm and closed on monday at 9 am it should only calculate 2 hours and not weekend hours. I am trying to work this logic out on our DB side (snowflake) but was wondering if something like this could be done on Tableau side.
any suggestions would be greatly appreciated.
Thank you in advance
Hello - hoping someone can help.
I am trying to create a percentage gauge to show percentage of total sales by team.
I have the gauge built, and my percent of total as a calculated field for the slices. The formula I have is SUM(sales) / TOTAL(SUM(Sales).
When I plug in the formula in a table by team it works, but for the gauge it is showing every team as 100%.
Any suggestions/help is greatly appreciated!
On the dashboard, how can I hide the distinct count title? I don’t see an option when I right-click and to hide the title. Thank you