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…
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…
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…
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…
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…
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 &…
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…
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…