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
1
vote
1 answer

REGEXP_EXTRACT unknown function on Tableau 10.0.1

I'm using REGEXP_EXTRACT function on Tableau trying to extract numbers from a string. My line of code: INT(REGEXP_EXTRACT([Name], '([0-9]+)')) My colleague can use it and I can't. Getting an unknown function error. We are both using the same…
Lina Linutina
  • 363
  • 1
  • 2
  • 17
1
vote
1 answer

Can I Create sorted filter shelf based off corresponding ID column

Tableau version: 10.2 I'm trying to order/sort my filter shelf based on a corresponding ID column that is specific from company to company. Currently, it sorts alphabetically since it's a string value. In our database, we have an ID column that is…
Seef
  • 35
  • 1
  • 5
1
vote
0 answers

Extract data from tableau server to r data frame

We currently have a database that can only be accessed via a Tableau front end. Is it possible with R (or any other means) to be able to extract the underlying data table into csv or txt? I don't really care what it ends up as so long as it is…
1
vote
2 answers

How to convert strings in Tableau Desktop, like we use "=Text()" function in MS Excel?

I am using Tableau Desktop 10.x, and have a LIVE connection from MS Excel file. I have a column with some numbers as below: 123 1234 12345 However, I want to change or create another column to see the results as below: ID000123 ID001234 ID012345 I…
HelloWorld024
  • 133
  • 1
  • 1
  • 11
1
vote
1 answer

Why Tableau full outer join is behaving like left join?

I want to join two tables on Tableau. I don't want to lose any entries so I'm using a full outer join: The data looks like this Table 1: Name1 Status Storage Certificate gbo001 Running 16GB on gbo003 Running …
Lina Linutina
  • 363
  • 1
  • 2
  • 17
1
vote
1 answer

Combining dimension values to create an additional dimension value

I have a simple sample data set: Name Database Amount Brian DC1 50 Brian DC2 100 Steve DC1 34 Bill DC2 90 Ed DC1 49 Suz DC2 82 I'm struggling to create a calc or formula…
Seef
  • 35
  • 1
  • 5
1
vote
2 answers

How to filter top customers within certain section in Tableau

I have a Tableau file whose source is from one Excel sheet as shown below: And it's how it looks in Tableau: I have a Tableau sheet to show me the top 3 customers in each section. For example, company F, H, J, B, A are in section XXX, I filter…
emma12345
  • 107
  • 4
  • 10
1
vote
2 answers

Tableau: graphically show compounded leadtimes

I have a chart that shows the number of departures for a given 15 minute interval as seen here. I need to compound these counts backwards for one hour. For example, the 3 departures shown at 11:00 need to also be represented at the 10:00, 10:15,…
Michael Byars
  • 117
  • 2
  • 13
1
vote
1 answer

Calculate LAG variable after filtering in Tableau

I have a dataset with 4 columns: ID (unique identifier of user), Year, Country and Level in this format: +----+------+---------+-------+ | ID | Year | Country | Level | +----+------+---------+-------+ | 1 | 2015 | USA | 1 | | 1 | 2016 |…
AlexD
  • 21
  • 4
1
vote
1 answer

Create subset and overall value line chart

This may sounds very simple but I am finding hard to get that. I have a data with value in one column and category in another column. i.e., Value Category Month 100 A Jan 300 A Feb 200 A Mar 459 B Jan 334 …
Lak023
  • 33
  • 1
  • 2
  • 5
1
vote
1 answer

Tableau count average from averages

There is some data: A, B, C (where C = A/B) 10, 20, 0.5 10, 100, 0.1 There are two ways of counting the average C: First is sum(A)/sum(B), that gives C equal 20/120=0.1666 This is Tableau: sum([A])/sum([B]) Second is avg(C), that gives C equal…
bry888
  • 263
  • 1
  • 4
  • 13
1
vote
1 answer

Sum Filtered Data in Tableau

I have a database of users and each user record has "User ID" and "Group". After filtering out a chunk of the records, I'd like to sum the number of users within each group. Currently I am doing that with the calculation: {FIXED[Group]:SUM([Number…
Dylan Stark
  • 2,325
  • 17
  • 24
1
vote
1 answer

Spark Thriftserver stops or freezes due to tableau queries

The spark cluster (spark 2.2) is used by around 30 people via spark-shell and tableau (10.4). Once a day the thriftserver gets killed or freezes because the jvm has to many garbage to collect. These are the error messages that I can find in the…
1
vote
1 answer

Displaying Max, Min, Avg across bar chart Tableau

I have a bar chart with X axis as discrete date value and Y axis as number of records. eg: x axis (Filtered Date)- 1st Oct, 2nd Oct, 3rd Oct etc y axis (Number of Records)- 30, 4, 3 etc Now, I have to create a table to get Max, Min and Avg.…
AYa
  • 421
  • 3
  • 9
  • 21
1
vote
1 answer

Tableau highlight few bars in chart

I have a tableau chart with categories (A-meaning of A, B-meaning of B etc) and the corresponding values of each category. Please find image as attached - I want to highlight the 3 rows starting with 'E' for this time because each capital letter…
rose zhu
  • 11
  • 1
1 2 3
99
100