Questions tagged [tableau]
The tableau tag has no usage guidance.
66
questions
0
votes
0
answers
11
views
Average of Percentages of the last 3 columns in the table, and Average of Percentages of the 6 columns
Hello! How can I get the average of %'s of rightmost 3 columns, and all 6 columns in Tableau? Please help.
0
votes
1
answer
21
views
Calculating row-level ratios in a table view
I am trying to get the fulfillment ratio by Destination Distribution Entity
Fulfillment Status is a property on a record called a 'directive'
I have no idea how to do this, any help is very ...
- 101
0
votes
0
answers
17
views
How to re-translate a forecast I wrote in R run on a dataset I downloaded from Tableau back into a SCRIPT_REAL function in Tableau
I want to add a SARIMA forecast of the next two days onto each line in the following Tableau graph:
But Tableau only does Exponential Smoothing forecasts and if I create a moving average table ...
- 157
0
votes
0
answers
12
views
How to aggregate in calculated field in an inclusive way
I want to use a calculated field that will aggregate based on a date range.
For example :
Publication ID
Year
xyz
2023
blah
2022
blah 2
2022
blah 3
2022
test
2021
test 2
2021
The result I ...
- 1
0
votes
0
answers
36
views
Tableau LOD calculation when using multiple fields
I have the following data:
Record Type
Description
Other
Pull Type
Membership
X
Actor
1
A
100
X
Actor
2
A
100
X
Baker
1
A
300
X
1
B
750
X
2
B
250
Y
Actor
1
C
75
Y
Actor
2
C
25
Y
Baker
1
C
...
- 1
0
votes
0
answers
21
views
Is there any way to relate/blend/join a Tableau published data source and an extract connection to a SharePoint List?
My small company is interested in combining two data sources together to a get a complete picture of workforce information. Here’s the problem:
Some of the data is housed in a Tableau Server ...
0
votes
0
answers
14
views
Tableau Geographic Map Visualization is filtering when cursor is over a city, unfilters when moved
I've made several Map style visualizations in Tableau and haven't experienced this issue in the past.
I've created a visualization of positions available at X organization by locations in various ...
- 165
1
vote
0
answers
18
views
How to get polygons to display 'room' or 'equipment' and not nest together?
I have a dataset where I have Rooms and inside the Rooms are pieces of equipment. The way the data is scrubbed is that equipment has an equipment name and room number and the room just has a room ...
- 11
1
vote
1
answer
372
views
How do I change the label of a Grand Total in Tableau Server
I have a simple grid with many columns and rows, with numeric data. I added a grand total row at the bottom by going to Analysis -> Totals -> Show Column Grand Totals.
The label for this row is ...
- 13
0
votes
0
answers
14
views
Restrict access at top level only [Tableau]
On the explore page, I have a folder structure. At the top level are 2 sub-folders (folder A and folder B).
Root
Folder A
Folder B
User created workbook i
User created workbook ii
I want users to ...
- 13
1
vote
1
answer
16
views
Filter across dashboard components
Is it possible to create a dashboard filter that will filter the data across all the components in the dashboard. For example, if all the components have quarterly data and have a quarter field, can ...
0
votes
1
answer
35
views
Tableau dashboard to easily show data from different quarters
I have 2 data sources linked that are the same format but from 2 different quarters. My boss wants to have 1 dashboard with an option to flip between the 2 quarters data so the graphs and things ...
1
vote
0
answers
38
views
Filter relevant geojson data based on a selected datapoint
I'll outline the situation and challenge I have a bit more clearly. I have multiple different datasets:
A set of locations where products are sold (name, long, lat)
A geojson dataset with geometry (...
1
vote
0
answers
11
views
Can I know if there's anyway to download Tableau report from server along with Title and Description in excel form?
I would like to download a Tableau report with the title footer and description written in Crosstab as it gets in PDF?
- 11
1
vote
1
answer
31
views
Cannot figure out how to make THIS particular data set long-form (theory, not even code)
I am a tableau developer, but I know Python, stats, and, in short, I think you all will be best able to solve my problem.
There is a universal filter on Facility. This means that any dataset/sheet ...
- 21
0
votes
1
answer
28
views
How to make good visualization of time series data using tableau?
The time series data looks like this:
Month
Count1
Count2
1
20
100
2
40
200
3
100
17
4
21
12
I have tried to use area charts or basic line/bar charts to visualize the two counts based on the ...
- 101
0
votes
1
answer
26
views
Limit Salesforce objects and fields in Tableau Desktop
In connecting Salesforce to Tableau Desktop it brings in every single object as a table. Within each table/object it brings in every single field. The issue is there are many standard objects my org ...
- 101
0
votes
0
answers
130
views
Are there any open datasets for commercial use?
I am creating a bootcamp for data analyst and it's been 2 days I am looking for some good dataset fit for commercial use that I can use to create Tableau and Power BI tutorials. Even on kaggle some ...
- 141
2
votes
1
answer
51
views
Tableau year-to-year change in grand total
New to Tableau and having some problems with a calculation I thought would be easy.
I have data with one value per month running across a few years. I would simply like to display a table with the ...
- 121
0
votes
1
answer
28
views
Drop duplicate / Get the unique value
Any idea how to drop duplicate values by 2 columns?
Here is the example. I want to get the first row if there's a duplicate value by 2 columns (customer_id , orderid)
I've done with making a count ...
1
vote
2
answers
34
views
Tableau Calculated Field Help
Tableau newbie here would really appreciate some help with a calculated field.
Let's say I have some data:
Patient ID
Appointment Date
10001
1/1/2019
10001
4/5/2018
10001
2/3/2021
10002
3/2/2019
...
- 11
0
votes
1
answer
26
views
use cases of geocoding maps
Tableau has interactive maps that can be used for custom geocoding. I know companies often divide regions for sales and marketing purposes but could anyone think of any specific use cases or examples ...
- 191
1
vote
0
answers
35
views
Tableau - Filter Buttons not filtering correctly
I created filter buttons to use as a filter for 6 category's (measures) in Tableau Public (latest version) so when you click on them the values for each display on my "Military Enrollment By ...
- 11
0
votes
1
answer
134
views
Tableau: keeping results independent of view / filter
I am using Tableau Desktop 2021.1.4
Suppose that my source sales data consists of 4 columns Region (dimension with values: N,E,W,S), Type (dimension with values: Furniture, Electronics, Appliances), ...
- 101
2
votes
1
answer
41
views
Organizing data sources when working with multiple tables from one database
I'm working with a workbook that has a dozen or so dashboards, each showing information stored in a different table in a MS SQL Server database. The information is pre-summarized, Tableau is just ...
- 173
0
votes
0
answers
56
views
tableau view with dimensions totals, static values and calculation
I try to create a table like the one following.
I got 1 line product, 1 dimension "zones" and I want to add few columns : total for pieces on a line, a fixe value for a product(stock mini), ...
- 101
3
votes
2
answers
60
views
Use Pivoted / Filtered Data as the basis for a Report?
I have a worksheet in Tableau that is organized into rows and columns and filtered on an aggregate calculation just the way I want it. I'd like to make a report based on this workbook's results but I ...
- 31
0
votes
1
answer
97
views
Un-Pivot Data in Tableau
Say you have data with fields named: A, B, C, KEY, VALUE.
And lets say the KEY field contains a discrete set of possible values like "X", "Y", and "Z".
How do you ...
- 101
0
votes
0
answers
39
views
Save CSVs as hyper file
I have three separate CSV files (Points.csv, PointsSynonym.csv, and LocalDataPoints.csv). I made these files after extracting data from shape files and .gpkg files.
I would like to save them all a ...
- 191
1
vote
1
answer
51
views
Three data sets in one plot in Tableau
The goal is to plot three data sets in one plot: (DATE1_GOOD, DATE1_BAD); (DATE2_GOOD, DATE2_BAD); (DATE3_GOOD, DATE3_BAD). Unfortunately, I'm getting all possible combinations:
So now the task is to ...
- 11
1
vote
1
answer
267
views
Why is my Tableau correlation coefficient different from what I calculated using Python?
I'm required to create a correlation matrix table using Tableau so I've created a version using Python to check if I did everything right.
The numbers are coming out different for both calculations. ...
- 111
2
votes
0
answers
24
views
Tableau - Take row-wise data and pivot it to have an output table based on separate table of product hierarchies
I have sales data with a unique customer ID on each row and their corresponding sales by Product on columns. I have a separate table for product hierarchy, which has a mapping of all products (column ...
1
vote
1
answer
366
views
Tableau: How to select data points in map to filter data?
I would like to filter my data to only present observations taking place in Berlin (where data points are concentrated in the image below). How can this be achieved? The only geographical information ...
- 111
2
votes
1
answer
44
views
Tableau can be used as a big datastore as well?
Company wants to use Tableau solution for visual reporting. The inputs are various files. The plan is to use latest SQL Server as database and server.
Q. Does Tableau has their own database ? Can ...
- 23
1
vote
1
answer
91
views
In Tableau, how can I create sub-category fields out of an overarching dimension?
I have a data set where it's more or less a star schema-like format, but in an Excel file. Don't worry about primary keys setup or any of that unless it significantly matters for answering this ...
1
vote
1
answer
81
views
Which visualization tool should I use?
We consider the below function :
$f(x,y,z,a) = x*y*z*a$, where $x,y \in \mathbb{Q}\cap[0,1000],$ $ a\in\{2,3\} $
and $z=z(x)$, taking values from the below table based on the level-range that $x$ ...
- 139
-1
votes
1
answer
51
views
Tools for a data science job [closed]
Could someone list out all the important tools and software required for a data science job? Example spark, tensorflow, SQL, tableau etc.
It would be helpful if you could list the domain and then 2 ...
- 482
0
votes
1
answer
844
views
How to draw line plot with multiple lines on Tableau?
I have 4 different measures which I want all on the SAME line plot. They do have the same scale. I tried dual axis but it doesn't work for more than 2 plots.
- 379
0
votes
1
answer
575
views
Dynamic Images in Tableau
A Tableau Workbook I'm working on has different users logging in to see the data for their company. In the dashboard I have created a dynamic image that shows the customer logo depending on who is ...
- 1
1
vote
0
answers
17
views
Tableau: Dealing with Date values [closed]
Im a noob at tableau. I have a quick question
I have data that doesn't explicitly list the date. (There is no column labelled "date" )
However there are columns with the following headers:
"Income ...
- 11
0
votes
1
answer
47
views
I am doing a forecasting for corona virus cases in NY, I have two models and not sure which one i should choose
I am using exponential smoothing and using tableau for forecasting. The first model I included trend and removed seasonality and it predicted the number of cases going up but the quality I got ...
0
votes
1
answer
163
views
How to Get Live Data Updates & Graphing with Tableau Public
I'm a big fan of Tableau's easy-to-use data visualization tools. I tried building dashboards with Python's dash package, but it was too complex for me and Tableau ...
- 143
13
votes
3
answers
3k
views
What do Python's pandas/matplotlib/seaborn bring to the table that Tableau does not?
I spent the past year learning Python. As a person who thought coding was impossible to learn for those outside of the CS/IT sphere, I was obviously gobsmacked by the power of a few lines of Python ...
- 143
1
vote
1
answer
271
views
Tableau: Clustering based on value-range for map coloring
Is there a possibility to cluster coloring for certain statistical ranges?
This is what I have been able to achieve so far.
- 71
1
vote
1
answer
1k
views
How to display an Heat Map (using Tableau or other BI tool)?
I've a simple dataset:
Id
Longitude
Latitude
Value
What can I obtain at the moment are "one map point" in every place.. Sum of Value don't affect "density" color.
I would like to display a ...
- 111
1
vote
0
answers
237
views
Self Union All in Tableau Public for Sankey Diagram
I'm following this 2017 YouTube tutorial from which I hope to learn Sankey diagrams.
At 2:28, he instructs us to select Convert to Custom SQL, after having opened ...
0
votes
1
answer
198
views
Connect Tableau and KoBoToolbox
Is it possible to connect kobotoolbox to tableau in any way?
Any kind of method would be much appreciated.
0
votes
1
answer
73
views
comparing data from first quarter in two years
How can I compare data from two quarters? What software can I use to do it parallelly side by side so I can compare them. What kind of factors can I take into consideration, I'm posting a sample data ...
- 21
1
vote
0
answers
69
views
Tableau: Displaying Averages and Aggregate Calculations In Filtered Visualizations
I'm new to Tableau and I just started by making a graph with multiple filters. What I want to do is display some averages of some columns and other aggregate functions dynamically as the filters are ...
- 11
1
vote
1
answer
123
views
Customer Targeting for CRM Marketing Campaign [closed]
I need help or ideas to solve the below business challenge. Sample questions has been provided. A snapshot of the sample data has been attached below:
- 13