Stack Overflow
Stack Overflow

Questions tagged [tableau-prep]

56 questions
2
votes
0 answers

Change the background of Text dynamically in tableau

Is there a way we could change , the color of the background in tableau dynamically. I have just used the Text Object , in text-Object I have taken name and < parameter >%. I would like to change color based on parameter value . Like less than 90%…
Kasis Shrestha
  • 75
  • 5
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 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
1 answer

Unable to aggregate on department level when I select an employee from filter

I am working on a Tableau dashboard in which I want to show an employee's salary in one sheet and the average salary of that employee's department in another sheet in the same dashboard. So it will look like below Employee Salary Department…
Jessica Yoskovic
  • 11
  • 2
1
vote
1 answer

Tableau Prep: How can I refer to a parameter in the Custom SQL query?

Using Tableau Prep Builder version 2021.4.4 I connected to Postgresql database (version 12) and created a Custom Query as the only input in the Flow. Then I created a parameter (my_date). In the custom query I have: select my_field from…
mtleis
  • 712
  • 1
  • 9
  • 28
1
vote
1 answer

I would like to display the whole graph as well as the latest highest and lowest points on the graph. How to do that in tableau?

For example: In sample superstore there are many days where lowest sales are 4. So I want to display only the point where there was a latest low of 4 and not all the 4's. If one value is repeated more than once then I want to display that value only…
Arpit Choudhary
  • 11
  • 1
1
vote
1 answer

Tableau Bar labels alignment

enter image description here Please help, I do not have a label alignment option on my bar graph. Is there a solution to this problem? I tried aligning the text inside the text box to the left or center but the labels did not move.
Masego
  • 13
  • 4
1
vote
1 answer

Can you call Tableau Prep parameters via TabPy in a Python Script?

I would like to know if the new parameter functionality in Tableau Prep can be called from a Python script when implementing a TabPy script in your flow? I am not sure how to call the parameter from the python function
Sara C
  • 31
  • 3
1
vote
1 answer

Tableau Regex Extract date from file name

I have a field that has the text file name being used as the data source. The file name is formatted like "file_name_example_2022-11-17_14.45.56.txt" with the "2022-11-17_14.45.56" being the date and time. I know I can do a series of RIGHT and LEFTs…
crazydiamond
  • 25
  • 4
1
vote
1 answer

Query Athena from s3 database - remove metadata/corrupted data

I was following along with the tutorials for connecting Tableau to Amazon Athena and got hung up when running the query and returning the expected result. I downloaded the student-db.csv from…
JacobJ215
  • 11
  • 1
1
vote
1 answer

Filtering date intervals by 15 min in Tableau

I have some fake account information that I am trying to learn Tableau on and need to be able to filter the date field (which is a timestamp mm/dd/yyyy hh:mm:ss) by 15 minutes. There are around 1,000 records on any given day. I have two ways that…
AlexF116
  • 15
  • 3
0
votes
0 answers

Creating a average column for specific dates in tableau desktop and or prep

I have created a tableau prep flow combining 4 different data sources. I was able to create a formula that categorizes 4 different data types... Historical Current Plan ETC the "current" data type consist of multiple weekly dates 6/30 | 7/7 | 7/14…
Jonathan Marin
  • 21
  • 5
0
votes
0 answers

Date Filter from 2 different dates in Tableau

I'm working in Tableau. Here is the sample of data EXAMPLE ID Start Date End Date 1 2011 2012 2 2011 2013 3 2012 2012 4 2010 2013 5 2012 2012 In…
Taras
  • 11
  • 1
0
votes
1 answer

Tableau Custom SQL Returns None from Big Query Table

Has anyone else experienced this issue? I have a query: SELECT * FROM `table-in-big-query` AS t1 INNER JOIN ( SELECT unique_Field, MAX(Upload_Datetime) AS latest_Upload_Datetime FROM `table-in-big-query` GROUP BY unique_Field) AS t2 ON…
beautysleep
  • 153
  • 1
  • 9
0
votes
0 answers

How to combine multiple last columns in Tableau?

Please help me!!!! So basically what I want to do is I want the Sum, average, minimum, and maximum for each column. It is only letting me chose 1 option, how do I pick all the options shown? Is that even possible?Image of Options I tried using…
khan3144
  • 1
  • 2
1
2 3 4