Questions tagged [tableau-desktop]
The tableau-desktop tag has no usage guidance.
tableau-desktop
753
questions
1
vote
0
answers
21
views
Group Concat Distinct creating new row for each combination? - Tableau Custom SQL
I am having an issue with my Tableau report where group concat is not working as intended. My table uses custom SQL and grabs from a BI connector sending information from MongoDB.
Let's say the ...
1
vote
3
answers
36
views
How to identify slabs based on a config table in SQL or excel
I have 2 tables, a Transaction table and Config table.
Based on the percentage achieved, I need to identify slab and rating from the config table.
Config table values can undergo changes including ...
0
votes
0
answers
13
views
Show trend for a calculation on a bar chart
I have a view that shows an outstanding balance based on the selected year-month value in the parameter.
The logic for the outstanding balance is as follows.
Amount of all invoices till the selected ...
0
votes
1
answer
24
views
Dynamic Date Filter/Parameter Tableau
I have a dashboard that shows total sales for a day as well as revenue. I have a filter on that dashboard that allows me to go between days and see sales for a specific day (not every day of the year ...
0
votes
1
answer
16
views
Joining and standardizing Country names in Tableau from different sources
I am calculating some metrics and need to standardize Country names on all sides in order to calculate it on a country level.
I have a transaction file consisting of two sql queries and external excel ...
0
votes
0
answers
19
views
Converting Text Field to Numeric in Tableau
I've been trying to convert a text field ($amount) into a numeric field. However, I keep running into an "Oracle database error 1722: ORA-01722: invalid number." Does anyone know why this ...
0
votes
1
answer
22
views
Calculated field to detail marks of 30+ worksheets
Is there a way to add calculated field to Detail marks of multiple worksheets in Tableau in bulk, or do I have to do this one at a time?
Selecting multiple worksheet and adding it to Detail marks did ...
0
votes
1
answer
34
views
How to create a calculated field in Tableau for Aggregated and Non-Aggregated Fields
I have a date field which is a calculated field ("SalesDate_current_month", this will give values True or False) from original date column (SalesDate). Trying to create a calculated field as ...
0
votes
1
answer
25
views
Tableau - Can we concatenate parameter values into single parameter which will be pass to CUSTOM SQL
I'd like create dynamic parameter which is concatenation of first 4 parameters. It should be dynamically changed which will be passed to CUSTOM SQL latest. Please share your views / solution to handle ...
0
votes
0
answers
21
views
Tableau Dashboard - Displaying view as a filter
I have a tabular report with seven attributes in total.
Account,r1,r2,r3, and r4 are in row shelf and Month in columns shelf with Amount as a measure.
Image1 shows the current view for month 1.
While ...
0
votes
0
answers
39
views
Attempting to build a Multi-fact Relationship model in Tableau - I don't seem to be given the option to add a second base table?
I am in a fresh Tableau workbook, Professional Edition v.2024.1.3 connected to a MS SQL Server database
I have two fact tables that are unrelated to each other, but share several dimension tables.
I ...
2
votes
1
answer
54
views
How do I make sure that a calculation is performed only once based on a unique value in a dimension in Tableau
I have produced a calculate field which calculated the percentage of a salary scale based upon how many hours that scale worked during a specific activity, for example VR. Now for each activity I want ...
0
votes
1
answer
38
views
Displaying data in one row for all attributes in Row shelf
I need help in displaying one row for each account name. Apart from the Account name, all attributes in the row shelf are calculated fields that say Yes or No based on the Amount in the Column shelf. ...
1
vote
1
answer
58
views
Is there a way in tableau to select the maximum value of a column, based on other columns?
I have three columns: a column of dates, a column of numerical values, and a a column of strings (states for example). I would like to create a column that assigns a 1 to any row in which the ...
1
vote
1
answer
50
views
How to summarize the total of a calculated if statement field, in Tableau?
I have a table that contains fields date, amount and Client_ID.
I want to get the count of clients who had an avg R3M greater than same period last year, for every month.
The issue is when I get a ...