Questions tagged [tableau-prep]
56 questions
0
votes
0 answers
Creating a Continuous and Timely Process with Python Notebook and Tableau
I'm seeking guidance on how to create a continuous and timely process in my organization. Currently, I have a Python notebook that extracts data from a database and performs various processing tasks on the extracted tables. The processed data is…

Segev Ohana
- 1
- 1
0
votes
1 answer
TABLEAU: How do I find the average for each year?
how do I find the average for each year's family income? it is from year 2000-2020.Thank you!
[2000 data sets](https://i.stack.imgur.com/3dliG.png)
[2001 data…
0
votes
0 answers
How to convert TWB file into TWBx file?
I wanted to open my TWB file. However, while opening the file from Tableau desktop it's giving me an error as I need to upgrade to a professional package, so is there any way I can do this without taking the premium version.
I tried online convertor…

Tushar Patki
- 1
- 1
0
votes
0 answers
Tableau Percentiles with fixed ranges
I have table A.
So for example in this case. 95th percentile would be 63 <= x < 65,96th would be 65 <= x < 67 so on and so forth. Anything below 95th percentile can be categorized as 94. It's not relevant.
These values are deciding percentiles and…

Uswa Mazhar
- 35
- 5
0
votes
0 answers
Tableau Prep and Rserve
I am trying to integrate R and Tableau better and using Tableau Prep to try to alleviate that gap. However, I am not able to get a simple R script to run using Rserve. I have exported the Titanic to excel and just using that in the process flow.
I…

Bills_Mafia_17
- 3
- 2
0
votes
0 answers
How do I filter a list of users based on clicking on a chart that is controlled by a parameter?
I have a list of users, and I'm tracking when these users have reached certain events.
My user list consists of
Name
User Created Date
User Role (3 types of roles - Engineer, Architect, and Lawyer)
Email
Country
Event 1 (Yes / No)
Event 1…

LionHeart
- 27
- 4
0
votes
0 answers
I need to create relationships In tableau between 5 different data sources. all data sources share 3 columns in common while 3 share an additonal one
Do I need to drag the files and have multiple versions of thes files in the relationship tab (such as hourly steps 0,1 and 2).
I feel like there is definitely an easier way to do this.
the three "hourly" files share an additional column, while all…
0
votes
0 answers
Text analytics - dataset to allow dynamic word list after selection in Tableau
Hi I have a table with the following raw data
Fruit 1
Fruit 2
Fruit 3
Apple
Orange
Banana
Banana
Orange
Pear
Grape
Orange
Pear
and trying to shape a dataset so Tableau can display a dynamic word list of any words in the same row as…

jjson
- 1
- 1
0
votes
1 answer
Linking Tableau to a Salesforce report with automatic refreshing
Tableau is currently lacking an out-of-the-box connector for Salesforce Reports. I am sure this will change at some point, but who knows when?
Currently it has a connector for individual Salesforce Objects, but if the schema is particularly…

alepoptosis
- 75
- 6
0
votes
0 answers
Tableau. Using current filter value to replace null values in a column
I am working on data viz on Tableau desktop
I have a dataset, with a column for dates, in this column , there are different dates, and null cells.
I need to use the dates in this column as filter, better still , page filters, however, I need to…

Pepin Peng
- 457
- 1
- 8
- 21
0
votes
0 answers
Tableau Help: Calculating Variable and Excluding a Filter when Visualizing Calculation
I am wondering if I can receive assistance on calculating a field with specific restrictions in Tableau.
Specifically, I am aggregating a variable ("Total Children") by geography using this underlying data (photos attached: underlying data &…

r2theoozbeck
- 1
- 1
0
votes
2 answers
How to create a column that captures record changes?
I have a table with customer records. When changes occur to records, the old one is kept and 'closed out' by updating end_Dt and Current_Flag, then a new record is added with the appropriate changes.
See example below:
Cust_ID
Name
Age
Phone…

Benjamin
- 29
- 3
0
votes
0 answers
How do I create an apply button that takes the values after passing it to parameter in Tableau?
I have the following parameters that defines each Asset. The parameters Von, Bis, Baureihe, Fzgnr..are defined for all the 10 assets. Currently, the tableau dashboard runs automatically once the values are entered. I want to create an apply button…
0
votes
1 answer
Selection in the Dashboard to reflect in the drop-down in Tableau Dashboard
I have created the dashboard as the cascading filter(1 filter when selected affects the choice of other filters) which is working fine in attached Sample. But I want that --> when I click on the house h2 within the sheet , that should get reflected…

Kasis Shrestha
- 75
- 5
0
votes
1 answer
Exact Date Syntax - Custom SQL Query
I am working on a custom SQL query in Tableau Prep using an Oracle data source. I usually write my SQL in another platoform, and am having trouble finding the right exact date syntax.
What is the correct syntax for the example below?
and (invc_date…

Kathryn Moore
- 7
- 3