Questions tagged [tableau-desktop]

774 questions
2
votes
0 answers

Trying to create a stacked bar chart, but cannot drag "Measure Names" to Color

I'm a first time user and every tutorial starts off with this step. My data looks like dept sold unsold A 4 6 B 8 9 I am using the free trial on their website if that makes a difference
John Smith
  • 291
  • 2
  • 12
2
votes
1 answer

Calculate count of rows with a dimension value Tableau

I want to create a Calculated field to display a Number when the Column/Dimension Outcome_Code == Death. EX: Out of 1000 rows if 400 rows has Outcome_Code == Death, then I just want to to display a big Number 400. If I give COUNT(Outcome_Code ==…
2
votes
1 answer

For Tableau, can we regex the word before a "word of interest", by creating a Parameter (a list of word of interest)?

I created the following Calculated Field in Tableau: REGEXP_EXTRACT(LOWER([Negative Review]), '(\w+)\s+(?=room)') My aim is to extract the word before "room" I believe Tableau allows me to extract other words, if my "word of interest" changes. As…
Chee Kong
  • 23
  • 3
2
votes
1 answer

Tableau remove row

could someone please advise how to remove blanks and zero for 2020 difference and percentage difference. I only wanted to find the difference from 2021 to 2020 where difference would be shown in one row only below 2021 and percentage difference in…
2
votes
0 answers

Tableau Extract Refresh keeps failing

Before I go completely crazy, I decided to ask here as well. My jobs have been running fine for months now, and I never had an issue. I have a workbook that uses 4 data sources. These data sources are refreshed every day at 6AM. The Tableau Server…
Djabone
  • 424
  • 4
  • 17
2
votes
2 answers

Cannot use generated fields in tableau

I am trying to make a flight path between origin and destination. I changed the geographic role of origin to Airport. Tableau automatically generated latitude and longitude for the origin airport. Now, I want to store these values into one…
darkexodus
  • 147
  • 1
  • 14
2
votes
1 answer

How do I use sum inside of nested IF in Tableau?

I want to calculate how many shopping points a customer would get based on the amount of spending and the date of their membership. Some customers order more than once, hence the nth.order column, but I want to use the total spending regardless how…
matchbox13
  • 73
  • 13
2
votes
1 answer

Calculated field affected the Grand Total in Tableau

Used a calculated field by using the window_max and window_min functions: IF ([eCPM]) = WINDOW_MAX(([eCPM])) THEN "Least efficient" ////Red ELSEIF [eCPM] = WINDOW_MIN(([eCPM])) THEN "Most efficient CPM" ///Green ELSE "Neither" ///Gray END But…
Esha
  • 57
  • 1
  • 8
2
votes
1 answer

Error while connecting to stored procedure in Tableau

I'm getting this error while trying to connect to a stored procedure as data source: Unable to complete action The stored procedure returned no results. The fields don't have column names, or the data in the fields is not a supported data type But…
MUM
  • 23
  • 3
2
votes
3 answers

Connect Tableau to Athena on Mac OS

Tableau Version 2021.1.2 Java Version openjdk 16.0.1 2021-04-20 OpenJDK Runtime Environment AdoptOpenJDK-16.0.1+9 (build 16.0.1+9) OpenJDK 64-Bit Server VM AdoptOpenJDK-16.0.1+9 (build 16.0.1+9, mixed mode, sharing) I placed the driver under…
2
votes
2 answers

Set the latest date value to the Quick Filter in TABLEAU

There is a live worksheet called Person with columns - Names & Birthdays. Need to create a quick filter with a default value pointing to the latest birthday. For example: If there are 3 Records as follows, Names Birthdays A 8/9/1993 S …
Avinesh
  • 584
  • 3
  • 13
  • 31
1
vote
1 answer

Tableau: How to create a calculated field that has multiple conditions and only works against other values in the same pane

In the screenshot below you'll see that I have multiple Vendors with their own Activity_IDs. There is a calculated column (called Modified Capacity) that tries to replace the placeholder value of 1000 with the max value from the Customer Count…
1
vote
1 answer

Tableau: Counting values in a sub group of a column

I have a table that has site, staff member name, and case numbers for each staff member. I'd like another column that shows (once) how many case numbers there are for each staff member. Now, I have this: Site StaffName Case…
Adam Chicago
  • 13
  • 1
  • 5
1
vote
2 answers

Tableau calculations for items opened prior to a specific date and closed after that date

I have two tables in Tableau: (A) one is a list of dates from the current day to 400 days prior and the other (B) is a list of ticket IDs along with open and closed dates for each ticket. What I'm trying to do is determine the number of tickets that…
1
vote
1 answer

Tableau - cannot mix aggregate and non aggreagte comparisons in IF statement

I am trying to do something very simple, and getting this error. IF [ORDER_LATE] = "Y" THEN [ORDER_QTY] END
1
2
3
51 52