Questions tagged [tableau-desktop]
774 questions
0
votes
1 answer
How to pick the highest value in each category in Tableau
I have to pick the highest value from col 2 in relation col 1 using Tableau. The data is as follows
col 1 col 2
category 1 5
category 2 6
category 1 4
category 1 3
category 2 10
category 1 1
category 2 3
The desired solution…
Nithya
- 33
- 4
0
votes
1 answer
In Tableau dashboard I have a metric which i should display in kilos, Millions and Billions automatically
I have a Measure in Tableau which has to be display dynamically in Kilos, Millions , Billions and also formatted as 200k, 2726M.
lakshman
- 41
- 5
0
votes
1 answer
Tableau filter based on data from month 1 and month 1 + 1
I am trying to count number of ids which meet certain requirements:
over 1k income for month a
below 500 income for month a + 1
how do I achieve this in tableau? I tried using the following calculated filed:
If {fixed [id],month[date]:…
peteraa
- 11
- 1
0
votes
0 answers
How to exclude weekend (Sunday only) to DATEDIFF in Tableau?
So my current formula is this: DATEDIFF('day', MIN([Date]),MAX([Date])).
How do I exclude sundays? and holidays.
COCO
- 15
- 1
- 7
0
votes
1 answer
How to use ATTR with Fixed LOD Tableau or any workaround?
How to make the calculation below work.
{ FIXED [Call_Count]:IF ATTR([Date]) >= MIN([Date]) AND ATTR([Date]) <= MAX([Date])THEN COUNTD([Date]) END }
I just need to get the number of days starting the first occurrence date to the Latest date…
COCO
- 15
- 1
- 7
0
votes
2 answers
How can I get the same week day from previous year in Tableau using a calculated field? For example the week day of 06/02/2020
I need to add the week day from previous year on the 3rd column.
Form example 06/02/2021 was on a Wednesday. I need the week day of 06/02/2021.
Thanks
0
votes
1 answer
How to show Prev Week, Previous Month, YTD in the same table in tableau?
I am trying to get the below table in Tableau.
week XX (previous week)
Month X (prev.Month)
YtD
20,000
100,000
400,0000
I am trying to compare the previous week with the prev month. So far I have got the following:
Firstly, I got the day…
alphasqrd
- 53
- 6
0
votes
1 answer
Calculate total time based on column in Tableau
I have a table like below:
From Date
Issue Id
Issue Id (group)
Status
Till Date
19-07-2021 17:21
4
4
Approved
19-07-2021 17:23
19-07-2021 17:23
4
4
In Progress
19-07-2021 17:23
19-07-2021 17:23
4
4
In Review
19-07-2021 17:25
19-07-2021…
Dhruv
- 43
- 4
0
votes
1 answer
how to get previous year values in datetrunc?
I have a calc to get current year external hires, but I also want to make a field that gets the hires from last year.
if datetrunc('year',today())-1 = datetrunc('year',[Start Date])
then [Start Date] else null
END
today()-1 would = 2020, but it…
NidenK
- 321
- 1
- 8
0
votes
1 answer
Using FORMAT_DATETIME with Tableau and BigQuery
I'm connecting to BigQuery to get information for a Sankey Diagram in Tableau. However, I am getting this information from 2 different datasets: "audience exited" and "audience entered". I am using the User IDs and the original timestamps to join…
Dylan Ndengu
- 43
- 7
0
votes
1 answer
How to summarize values when column values are identical?
I am pretty much using Tableau as a pivot table here. How can I summarize the order volume column so that, because all of the previous column values are the same, it will read as 3 instead of 1 and 2? Sum() hasn't worked for me.
Thank…
cosmopog
- 3
- 1
0
votes
1 answer
Tableau server installation: Missing multiple .jar files error
I am getting multiple .jar file missing errors while starting the tsm server. Adding some messages below (also complete log attached).
Tableau Server 2020.2.8 on CentOS 7.9.
java.io.FileNotFoundException:…
Jay
- 1
0
votes
1 answer
How to find from where SQL syntax error of ; and ) is coming?
I see an error
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ';'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.
when trying to run the following on Custom SQL on Tableau…
Sadaf Fatima
- 11
0
votes
1 answer
How to view the Tableau workbook in server mode before publishing?
Some of the modifications made in the Tableau workbook are not being reflected when published into the server. I am wondering how to view it in server-mode before publishing it to make the appropriate changes instead of re-publishing it all over…
Keiko
- 61
- 12
0
votes
1 answer
How to bring column header from Top to bottom?
Tableau sheet
I basically want to bring the column header(The one with countries name) from top to bottom.
I tried to the analysis -> Layout options -> advanced -> show innermost level at bottom.
I tried looking everywhere and this was the only…
Dhiraj D
- 63
- 8