Stack Overflow
Stack Overflow

Questions tagged [tableau-desktop]

774 questions
1
vote
1 answer

Replicating Sumifs

I am relatively new to tableau and I am trying to replicate a sumif as a calculated field in tableau. I have seen posts online where you can use SUM(IF [Broker] = "Broker1" then [settleamount] end) as a way to replicate SUMIFS($Q:$Q, $R:$R =…
monkey1009
  • 11
  • 2
1
vote
1 answer

Tableau line chart with complex conditions

I have data look like this. I want to create line chart that show year_number on x-axis and show kpi_value on y-axis, but there're complex condition that I want to show kpi_value only from max month of each year, if you see on the data in year 2022…
Surat Suntong
  • 31
  • 1
1
vote
1 answer

Filter data by selected values from a list

Tableau version: 2021.2.8 Hello All, I have a column that has the fee codes listed in comma separated format. for ex: (1,2,3,4,5,6,7,8) The requirement is to include contracts with fee codes 1,2,3 or 4. There were multiple possible combination 1,2…
Prdp
  • 47
  • 6
1
vote
1 answer

How do I map a data dictionary to coded data?

I have a massive dataset from a government entity that I am trying to analyze. The data dictionary is about 22k rows. All of the data in the dataset is coded like this: coded data sample Typically, I've worked with small datasets and have just…
Mike
  • 11
  • 1
1
vote
2 answers

Create a calculated field in Tableau that will show me the Employees that are in the same location as their Manager

Given the following dataset below I would like to create a calculated field that will show me the Employees that are in the same location as their manager. So for example Employee ID 1 would be in the same location as their Manager (Employee ID 5)…
harcot
  • 317
  • 1
  • 4
  • 7
1
vote
1 answer

Revise SQL for Tableau instead of subquery

I have the following code in SQL that I need to modify to Tableau native logic, preferably without the use of initial sql or custom sql. Whereas the following code is limited to one time period I need to use multiple time periods. See the line with…
bert
  • 23
  • 3
1
vote
1 answer

Tableau LOOKUP & FIRST / LAST value

Good morning, In Tableau, I have a list of shifts that have : Planned start time Planned end time For each shift, a person has to log-in and then log-out. Someone can log-in and log out multiple times during a shift. So for a given shiftnumber…
morg
  • 1,173
  • 4
  • 18
  • 36
1
vote
0 answers

Column updating with Tabpy in Tableau Desktop

I don't know why my column is not updating while my Tabpy is connected with Tableau even with the easiest requests possible enter image description here My Tableau version is 2020.1 and my Tabpy version is 2.6.0 I was primarly running Tabpy on my…
Antoine Masnata
  • 11
  • 2
1
vote
1 answer

Tableau: Convert Stacked Bar Chart with Multiple "Measure Values" to a normalized 100% Stacked Bar Chart

This is what my current view looks like. Right now my Tableau chart shows the breakdown of average fare, Grouped By different Community Numbers. I would like to also show a version of this chart that normalized all these stacked bars into 100%…
Katsu
  • 8,479
  • 3
  • 15
  • 16
1
vote
1 answer

How to return the frequently occurring day in TABLEAU?

I am working on a dashboard in Tableau where I want to display in a scorecard type of chart the busiest day. I have a data column in timestamp format and I wanted to be able to extract the day of week then show only the most frequently occurring day…
nanaoli
  • 11
  • 1
1
vote
0 answers

Use DAX Measure in "Values" or "Legend" Field in Power BI Scatter Plot

I have a DAX Measure that I need to use in either the "Values" or the "Legend" Field. I am unable to accomplish this as a calculated column because the Measure relies on a Parameter Value attached to a slicer which cannot be used in a calculated…
bensmith87
  • 135
  • 1
  • 1
  • 12
1
vote
1 answer

ERROR: column reference is ambiguous Position in Tableau for mac

I get this error 'ERROR: column reference is ambiguous Position. Error Code 6BF19D1C' running the next query on Tableau for mac on PostgreSQL 15.2 SELECT * FROM magasin join ville_mag on magasin.ville = ville_mag.ville join vente_bonbon …
Leila Nikonova
  • 115
  • 4
1
vote
1 answer

Tableau: Return entire row based on Min or Max value of specific column

I'm teaching myself Tableau and occasionally run into challenges. I have a dataset like the one below and I'm trying to create two calculated fields to display either the row that has the minimum value for the sum of the columns or the maximum value…
VonHugenstein
  • 109
  • 2
  • 10
1
vote
0 answers

Building Data Dictionary /Business Glossary from large Tableau Workbooks

I am trying to build tables from some large Tableau workbooks where the columns would ideally be: Worksheet- the worksheet name **Description **- the description under "sheet description" (ctrl E) that tells a description of the sheet Dashboard-…
Michael Ferral
  • 13
  • 2
1
vote
0 answers

Tableau - restrict access for specific filter

I'm working with Tableau - and I have a workbook that hold Cost values for many departments, I want to give limited access to this workbook for each person. I have a filter for "Department" - and I want to give access to let's say 2 out of 10…
Bramat
  • 979
  • 4
  • 24
  • 40
1 2
3
…
51 52