Questions tagged [tableau-api]

For software development questions related to the use of developer API for Tableau Software, a family of interactive data visualization products

Tableau Software is a family of interactive data visualization products focused on business intelligence. There is also a developer API for creating data extract files, and a developer API for JavaScript interaction, which provides more custom ways to interact with Tableau reports.

Main Features:

  • Connect to a large variety of data sources, including MySQL, PostgreSQL, Teradata, BigQuery, Redshift, Google Analytics and Salesforce.
  • Has option to extract data to a Tableau format (tde), which is a columnar database, with good compression and high performance.
  • Drag and drop environment, little or no SQL knowledge necessary to perform most of the tasks.
  • Large set of reports available, and options to create very interactive dashboards, such as custom parameters, using charts as filter for other charts, interactive filters
  • Tableau Server allows users to have access to reports via web browser.
  • Tableau Public provides free hosting of publicly-accessible reports with limited features.

When posting questions, Tableau Public is an invaluable resource. Problematic workbooks (or example workbooks demonstrating the issues in question) can be published here to help answerers find the problem more quickly and give a more thorough solution.

In addition to Stack Overflow, a good place to get solutions to Tableau questions is on the vendor's forum.

5440 questions
4
votes
2 answers

how to query a partitioned table in bigquery from datastudio

This topic was covered for tableau here: How to query a partitioned table in BigQuery from Tableau but I don't think you can insert parameters into datastudio yet.
Ralph
  • 65
  • 1
  • 6
4
votes
2 answers

How can I calculate a distinct count of a dimension in Tableau?

I have Googled this and searched the Tableau forums but I'm coming up empty. How can I calculate a distinct count of City Names using Tableau?
Tarzan
  • 4,270
  • 8
  • 50
  • 70
4
votes
1 answer

Tableau connection to Spark SQL

I am trying to connect Tableau Desktop 10 (mac) to Spark SQL 2.1 (on centos 7 server). I am connecting via Simba ODBC driver with Authentication = Username and Username = . It doesn't give any error but I don't see the tables which are available in…
4
votes
2 answers

Tableau Dual Axis with different filters

I am trying to create a graph with two lines, with two filters from the same dimension. I have a dimension which has 20+ values. I'd like one line to show data based on just one of the selected values and the other line to show a line excluding that…
kshankar
  • 43
  • 1
  • 1
  • 4
4
votes
2 answers

A pandas to_tde function for Tableau Data Extracts?

I know that Tableau is fairly popular so I cannot be the only person who is using the Python TDE API to get data into the compressed Tableau format. Documentation 1) This API is only Python 2.7 and it is literally the only reason why I need 2.7…
trench
  • 5,075
  • 12
  • 50
  • 80
4
votes
0 answers

Loading data for analysis in R and Tableau

I'm trying to use R and Tableau interactively, to run a model in R and visualize the results in Tableau. My understanding is that the modeling data should be loaded in R. I wrote this Calculated Field in Tableau to try to load data in R, however it…
Hack-R
  • 22,422
  • 14
  • 75
  • 131
4
votes
2 answers

Tableau data extract refresh from Google BigQuery takes very long

We are very pleased with the combination BigQuery <-> Tableau Server with live connection. However, we now want to work with a data extract (500MB) on Tableau Server (since this datasource is not too big and is used very frequently). This takes too…
Fematich
  • 1,588
  • 14
  • 26
4
votes
1 answer

Aggregating from multiple columns in Tableau

I have a table that looks like: id aff1 aff2 aff3 value 1 a x b 5 2 b c x 4 3 a b g 1 I would like to aggregate the aff columns to calculate the sum of "value"…
Alex R.
  • 1,397
  • 3
  • 18
  • 33
4
votes
4 answers

Color code only one column in tableau

I would like to color code the last column "difference in ratio", red if less than -10%, green if above 0%. Right now, it color codes the entire the data. How can I limit to only the last column? I attached the link to the file for your review.…
John
  • 79
  • 1
  • 1
  • 7
4
votes
1 answer

Date diff with milliseconds with Tableau Software

In Tableau Desktop, I've got two date dimensions representing the begin date and the end date of an event. To know the duration of an event, I do DATEDIFF('second', [begin date], [end date]). Unfortunately, some events last less than one second so…
Benoît Guédas
  • 801
  • 7
  • 25
4
votes
2 answers

How to normalize data to a range in Tableau

In Tableau, I am trying to implement the following normalization logic: https://stats.stackexchange.com/questions/70801/how-to-normalize-data-to-0-1-range Basically, I want to take all values from a particular measure and scale them to values in the…
glonn
  • 159
  • 2
  • 9
4
votes
1 answer

Is it possible to create user defined functions in Tableau? If yes, what coding language it uses?

Tableau has many in-built functions but if I want to create my own functions and save it, is it possible to do so?
Sharma
  • 51
  • 1
  • 2
4
votes
1 answer

Aggregate an Running Sum in Tableau?

I have a simple data set showing the number of points scored by a player. It is plotted across a [Week Number] x-axis. I added a Running Sum calculation, as a Line, split by Player (color). For each week, I would like to identify the top player,…
Rob McCauley
  • 538
  • 1
  • 5
  • 12
4
votes
1 answer

TABLEAU: calc field to get the last value available

I'm using Tableau Desktop, my data are like this: KPI,date,monthValue coffee break,01/06/2015,10.50 coffee break,01/07/2015,8.30 and I want to build a table like this KPI, year(date), last value coffee time, 2015, 8.30 How can I set a calculated…
stegue88
  • 63
  • 1
  • 1
  • 5
4
votes
1 answer

Reusing Tableau Worksheets in a Dashboard

is there a way to reuse worksheet multiple times in a dashboard, perhaps by using parameter? I have a dashboard with 4 sheets, displaying similar thing (differs only on the data filtering).
Panji
  • 133
  • 1
  • 7