790 questions
0
votes
1
answer
42
views
Calculated filter field not passing on only relevant values to another field
I have a calculated field (total count) to sum the volume of a field called reason volume by an application id.
{FIXED [APP ID]: SUM([reason volume]}
This works great. It displays the number of ...
Advice
1
vote
0
replies
29
views
Tableau checkbox filters for multiple fields with 1,0 values
I've been researching for hours and cannot seem to figure out if this is possible. I have a about 40 fields that have a 1 or 0 value. I want to have a filter for each field and the ability to select 1 ...
1
vote
1
answer
38
views
Tableau Table - Double and Single Layer Column
Is it possible to create a Tableau table wherein there are two-layer columns and one-layer columns in a single sheet? The months can show up to 12 months but the YAGO and 2023 will always be based on ...
1
vote
1
answer
30
views
Date Calculated Field is not showing in parameter in Tableau
I am trying to create a date parameter based on a calculated field.
Here is the calculation:
SetMinDate:
DATE(MIN([Gift Date]))
but when I go to create the paramenter, it doesn't appear as an option ...
0
votes
1
answer
58
views
How to replace blank values with 0 in a heatmap?
I have a heat map as shown in image.
For white regions blank there are empty rows and columns.
Verification done:
SELECT * FROM final_concurrency where region = 'APSE1' and weekday_name = 'Sat'
This ...
0
votes
1
answer
53
views
Creating 0 or blank values in a table on tableau
I'm having difficulty trying to get a table to work. I current have Tableau counting the number of times a person gets a rating and accumulating this into a number used the following. I added the last ...
2
votes
1
answer
131
views
How to set default value for parameter to be the max value of a field
I am creating a dashboard on some data and I need to add a new filter and make the default value of it when the workbook opens to the max value.
For example, if the field has values [1,2,3,4,5,6,7,8,9]...
2
votes
1
answer
54
views
Tableau: Format % with 4 decimals for "Annuity Insurance", 2 decimals for others, and preserve trailing zeros
In Tableau, how can I dynamically format a calculated percentage to show 4 decimal places for 'Annuity Insurance' and 2 decimal places for all other products, while preserving trailing zeros like 0....
1
vote
1
answer
61
views
Tableau Dashboard: Grand total row when no additional filters are selected and summarize rows when additional filters are applied
I have a tableau dashboard that is always filtered by Report Quarter and Paid status.
When these are the only filters, i would like the grand total row, which is precalculated to be displayed. The ...
1
vote
1
answer
113
views
Tableau : how to implement UNION in a calculated field
I have 3 dimensions (3 columns) in a table. I want to create a calculated field where I can bring all 3 dimensions using a UNION approach. This calculated field will further be used in my dashboard.
...
1
vote
1
answer
94
views
By using a year parameter in Tableau,How to create a range of dates including selected year dates and next year
i created a parameter "Select_Year" as a list of DATE type that showing following years: 2020,2021,2022,2023. I want to create a calculated field which s filterd by the parameter and showing ...
1
vote
1
answer
87
views
Count the Number of Weekends in a Period of Time in Tableau
Based on a single dimension called [codes], I have a [start_time] for each user that took the code (they can take the same code multiple times). The start times can repeat for every record as a user ...
0
votes
0
answers
48
views
Week Level Disappears After Applying Filter in Date Hierarchy (Year > Quarter > Month > Week) in Tableau
When I add a filter (like Filter: True) in filter shelf, the week level disappears in my hierarchy (Year > Quarter > Month > Week).
But I want the Week to remain visible after adding filter ...
0
votes
0
answers
27
views
Adjust workflow between openxlsx2 (R) into Tableau
I have a dataset that I put through the following workflow:
Raw data is .xlsx
Clean data using R
Write to a specific sheet in an existing Excel file using openxlsx2 (My colleagues use other tabs in ...
1
vote
1
answer
50
views
Line Chart and Circles With Matching Circles in The End (Filled or Unfilled)
I have a dual axis line chart. One is the line, the other is selected as circles.
I want to add either an open circle or closed circle depending on a closed field, at the last year of the line chart.
...
1
vote
1
answer
82
views
Add YTD column next to Monthly column
In Tableau, I need to create a monthly overview that analyzes actuals, prior year, and target for a few KPIs.
Is it possible to add a new column next to the month to show the YTD value?
Please see the ...
1
vote
1
answer
35
views
How to Calculate Total Count of Actions by Department in Tableau?
Question:
I have a dataset that includes columns for PID, Department, and Action. The Action column contains entries such as "Term Review." I am looking to calculate the total count of "...
0
votes
1
answer
29
views
Find the difference between each unique title per quarter
I'm trying to display the difference in quantity between each title based on each quarter. Here's the sample table:
enter image description here
I'm able to display each title by quarter, but I'm not ...
0
votes
0
answers
110
views
How to resolve this error: "No Clients in Tableau Bridge Pool"?
I created a Tableau Dashboard through an API Integration of Smartsheet with Tableau. Now I'm getting the error "No Clients in Tableau Bridge Pool" with error description "Bridge live ...
0
votes
1
answer
15
views
Assigning Specific Colors to Disciplinary Actions
I have a formula that looks like this:
I'm trying to assign specific colors to different disciplinary actions and highlight the entire cell. Here's my formula:
IF ATTR([New Hire]) = "N" THEN
...
0
votes
1
answer
37
views
Plotting numbers in Tableau
Let's say I just want to plot a xy curve or something similar. For the example let's say that the data is:
x y
-1 2
0 1
1 2
2 5
3 10
How does the concept of "...
0
votes
1
answer
138
views
Tableau cannot connect to a data source: HybridDialog JS is not responding across webchannel
While trying to connect to a Tableau data source for a new workbook, the following error is raised:
Unexpected Error
HybridDialog JS is not responding across webchannel. Aborting show
Error Code: ...
1
vote
2
answers
116
views
Recursive CTE can only work with temp table as initial SQL in Tableau
I'm trying to use recursive CTE in Tableau. I reazlized this doesn't work when running custom SQL, but I can create a temp table
CREATE TEMP TABLE temp_table as
WITH RECURSIVE missing_dates_cte (...
2
votes
0
answers
57
views
AG Grid React Crashes Inside Tableau Extension Due to Invalid CSS Selector ':not(title, meta)' DOMException
Description
While using AG Grid v33.2.1 within a React application embedded as a Tableau Dashboard Extension inside Tableau Desktop, I encounter a DOMException due to an invalid selector originating ...
1
vote
1
answer
48
views
Sum Unique Value in Table
I have this table in Tableau which is made of many relationships from various tables.
The main idea is to associate with As of Table to calculate the rolling value.
Here I want to get the rolling 6 ...
0
votes
0
answers
25
views
Tableau Calculated Field for Summing Duration and Assigning Credits Used
Question:
I'm working with Tableau Desktop and have a dataset where [PID], [Start Date], and SUM([Duration]) are repeated. I need to sum the Duration for repeated [Start Date] values and ensure that ...
1
vote
1
answer
97
views
How to create only one checkbox filter in tableau dashboard?
I have a column in my table which is department which has values as engineering and non-engineering. I need to implement this as a filter in tableau dashboard but it should show only one option which ...
0
votes
0
answers
63
views
Tableau: Clear Button to Reset Multi-Select Filter Not Working
I’m trying to create a Clear Button in Tableau to reset a multi-select filter for a field called list.
I followed the steps to create a parameter and a calculated field to clear the selection, but it ...
0
votes
0
answers
15
views
Tableau Web Data Connector - How to Display Categorical Labels Instead of Numeric Codes?
I am working with Tableau's Web Data Connector, using a link from a corporate data repository. However, several categorical variables are displayed without their labels—for example, the "sex"...
1
vote
0
answers
36
views
Is there a way in Tableau to go through a series of numbers in a field (delimited by ",") then do a lookup for each from another data source?
I have a series of IDs in a Tableau column that I need to derive the actual names from another data source (like a vlookup or join via the ID), and display the actual names on a new Tableau field. See ...
0
votes
0
answers
35
views
Rows Calculation using SUM & IF function for Empty / NULL value on specific field is not calculated
I have 2 table that all filters are link to each other except for 1 field called "Defect Type" that do not exist in first table.
https://i.sstatic.net/M6HtFUOp.jpg
For second line graph (...
0
votes
0
answers
30
views
Filter out duplicates created by Tableau Desktop (values don't exist in Snowflake view)
Background
I want to display the total worked hours for specific user_id's per day.
I created a view in Snowflake that shows this data, together with other metrics.
In the view, I see that on day X, ...
1
vote
1
answer
141
views
How can I change the text size depending on a field size in tableau
I want the more 'awesome' news to be bigger and vice versa. The variable is called 'Awesomeness' and the text variable is called 'Headline'.
The tableau table I'm trying to make pretty
I dont want to ...
0
votes
0
answers
44
views
Change x axis start and end based on parameter selection WITHOUT filtering data
I am plotting box plots for a very large distribution of data, 0- >350k. The users need to be able to see the entire distribution without effecting the box plots. If I apply a filter and filter ...
0
votes
0
answers
70
views
Label a Tableau Boxplot with the total number of points in each column
I have a Tableau box and whisker plot of the duration of task executions by fiscal year. There are filters applied to the visualization, so with each year there could be anywhere from a just a few to ...
1
vote
1
answer
56
views
Adding trend line to a discrete field in tableau
I have been trying to add a trend line to a discrete (blue pill) field and I can't able to do that. I have tried other ways which is creating a calculated field and using it to the sheet but it is not ...
0
votes
1
answer
91
views
How can I make this line chart with smooth line in Tableau
I am new to Tableau.
I want to make a line chart like the one shown here (Sorry for the quality of the image the app I took it from doesn't allow screenshots due to security policy):
The difference ...
0
votes
1
answer
74
views
Calculating Average Distinct Count in Tableau Without LOD and Without Displaying Months
I'm working with Tableau to analyze a dataset of insured people, and I need to calculate the average number of distinct insured individuals ([Cod Asegurado]) across the 12 months of a year. I want to ...
1
vote
0
answers
84
views
Tableau Amazon DocumentDB Connector - Package Signature Verification Failed (Error Code: 14D18B1F)
I am trying to connect Amazon DocumentDB (MongoDB-compatible) to Tableau using the built-in DocumentDB connector. However, I am encountering the following error when creating the connection:
Error ...
1
vote
3
answers
159
views
How to change the datasource?
I have created a dashboard in tableau where I have 2 data sources with the same fields. I want to change the data sources using user input from a dropdown list. How can I change the data sources ...
1
vote
0
answers
53
views
Tableau complex Filters to get top 50 after other filters
I am changing this to I think simplify it. I am using a live query from Tableau to Snowflake. The Query contains a Random() number called Audit_ID. The Dashboard has several filters but generally it ...
2
votes
2
answers
435
views
How to install a Denodo driver
I've installed the Tableau desktop app and I need to make a connection using the Denodo JDBC by Denodo Technologies option.
No suitable driver installed, or the URL is incorrect
Connector Class: ...
0
votes
3
answers
311
views
Can we increase fetch size from 10000 when we fetch data from Redshift using Tableau?
asking this question as DevOps guy. I don't have any experience on tableau side of things. So scenario is when Tableau team in my org doing a refresh its getting timeout continuously. So when refresh ...
0
votes
0
answers
14
views
Consistent Color Coding for Organ-Specific Biodistribution Data (column features as function of timepoint)
Hi,
I'm trying to implement a consistent color coding for organ-specific biodistribution data across multiple sheets in Tableau. My dataset is structured such that each organ is represented by its own ...
0
votes
1
answer
48
views
How do I get a sum of dates logged in? (Assume it's a fixed LOD expression)
Really stuck on this. My data is structured like in columns K:L. I want a calculation that will give me the expected result in column G (6). I'm assuming this is a LOD formula but I've tried a few ...
0
votes
0
answers
22
views
How to put different splits into one filter without combining the data from the splits back together?
I'm a Tableau newbie. I have a list of companies with a combined list of majors. I divided my majors list into 10 different splits, how can I put all my splits into one filter without combining the ...
0
votes
0
answers
137
views
Server Permission Error while integrating Tablaeu to Amazon Athena
I've established an S3 bucket that has a Glue Table Scheme, and while trying to integrate it with Athena through Tableau, the Tableau Athena connector gives the following error:
Bad Connection: ...
1
vote
0
answers
57
views
while connecting my db with tableu i get this error
while connecting with db with postgrese i am facing this why?
Unable to complete action
Bad Connection: Tableau could not connect to the data source.
Error Code: D84EA4A5
FATAL: invalid value for ...
0
votes
1
answer
82
views
Connect to Heroku PostgreSQL using Tableau ODBC and SSL
I'm trying to connect to my Heroku PostgreSQL database through Tableau and ODBC, this needs to be over ODBC because it needs to be SSL connection. This being said, I have configured a User DSN. I ...
1
vote
1
answer
70
views
Tableau Take max year value in a table
I have the following data in tableau
Year
Values
2021
202
2022
212
2023
100
2024
280
What i want is the Year Max values in this case 280 and i want it to be dynamic so that when the Year change to ...