Stack Overflow
Stack Overflow

Questions tagged [tableau-prep]

56 questions
0
votes
0 answers

Using IF statement with Fixed LOD

Excel1enter image description here  Excel2 enter image description here output expected in tableau enter image description here I am having two data sources. One is Excel_1 and other coming from Excel_2. Now I have to extract some rows' data…
Shazzy
  • 1
  • 1
0
votes
0 answers

How to keep only the oldest date in a text table view of Tableau?

Data Source Image I have a data source with some treatment start dates. I want to see only "One date" which is the "oldest date" with its site name in it. I don't want to show the remaining dates and its site names in it Can any one help me to…
JAY
  • 1
  • 1
0
votes
0 answers

Create a calculative parameter and display it

How to calculate the fields as per screenshot --> store it in parameter --> display the params in Dashboard ? I created the parameter A1,A2,A3 and A4. Even tried to create the calculated field but didn't have success .
Kasis Shrestha
  • 75
  • 5
0
votes
1 answer

Tableau - YML file as data source

I have a .yml file that contains some data the I need to use in my Tableau dashboard. I didn't see that Tableau can directly use .yml as a data source (as it uses .xls, etc). Does that mean do I need to convert my .yml to something supported by…
DataPy
  • 209
  • 2
  • 10
0
votes
0 answers

Tableau : Click in the field of bar-graph changing Date parameter

I have a pretty simple use case. I have the Bar-Graph where one of the X-axis is Date Field grouped together on data to form the image attached below . So , I want that whenever , I change click on any of the Stick of bargraph , then the StartDate…
Kasis Shrestha
  • 75
  • 5
0
votes
0 answers

Error when trying to connect to oracle data source

Tableau version: 2021.2.8 Oracle version: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi We have a tableau report built on oracle database. The data connection built using custom sql using multiple joins. We are getting below error…
Prdp
  • 47
  • 6
0
votes
2 answers

Tableau Online: How do I get rid of the automatically displayed 'Abc' column when adding a field to Rows?

I'm trying to put together an Excel style report on Tableau where the rows have an id and some aggregated fields. Eg. id | sum(revenue) | sum(hours) 1. 100. 10 2. 200. 20 3 399. 40 However, whether…
T. Young
  • 153
  • 13
0
votes
0 answers

Tabelau - how to avoid filter value for particular sheet

I have been using tabcmd to export the dashboard as a pdf. I want to apply a filter for a particular sheet only but tabcmd applies the filter values to all sheets tabcmd export…
uvan
  • 37
  • 7
0
votes
0 answers

Forbidden error HTTP Status 403 for Tableau getUnderlyingDataAsync API

I am using getUnderlyingDataAsync JS API to fetch data and to check the rowcount for a sheet for my local validation purpose and it works for creator role and not working for viewer or worker role. I got the below error. Is there any way I can…
Prabhakaran
  • 1,264
  • 2
  • 20
  • 47
0
votes
1 answer

How do I spilt airbnb amenities data into multiple rows in Tableau Prep?

I need to split the following type of data into separate rows in tableau Prep Builder. There are only 2 columns: listing ID and Amenities like so: Listing ID | Amenities ------------------------------------------------ 123 | ["Oven",…
Dermo909
  • 128
  • 7
0
votes
2 answers

Dataframe object not callable when working Python script moved from Replit to local TabPy server

I have written a Python script that calls a National Oceanic and Atmospheric Administration (NOAA) endpoint with a zip code and gets a list of weather stations in response. The script then converts the response to a Pandas dataframe. I believe I…
mxs
  • 615
  • 6
  • 17
0
votes
0 answers

Tableau - Filter only on some variables in a sheet

I would like to add a filter to a sheet in Tableau. My problem is that it should not filter on all variables in the sheet, Is that possible? It's a date filter ( week number) and some of the rows in the data don't have a date, but should not be…
user371690
  • 1
0
votes
0 answers

Grant total of data using LOD in tableau

I am new to tableau & having data in the form of the below input dataset. COMPANY Id,Name,Month,Salary 1,SAM,AUG,10000 1,JOHN,JUL,20000 1,JACK,AUG,30000 2,TOM,AUG,20000 I need output in the below form COMPANY ID, MONTH, MONTHLY SALARY, TOTAL…
Aryan Tyagi
  • 71
  • 6
0
votes
0 answers

set up the default value to be the most recent pay period taking into account the date or the the most recent year

I have a discreate column ( Pay Period number ) from ( 1 - 26 ) & another column ( Date ) ( 2010, 2011 ,.... , current ) . I already have filter in the dashboard ( Pay Period number ) . However I want to set the default value to be the most recent…
AAA
  • 157
  • 1
  • 12
0
votes
0 answers

How to find the overall avg and compare each row (line item) to it

I'd really appreciate any help on this: Background on my data: [Date] (down to hour level), [Volume] -> Volume is equivalent to SUM[Number of Records] How do I find the [avg volume (for each line item - each hour of each day) + std.dev (volume -…
Abi Lowe
  • 1
1 2
3
4