
Marcel Leonardo Sarmiento Molano (Member) asked a question.
Josh Delekta (Member) asked a question.
Hello,
Please see attached. I have a case statement that I use for custom approval order. The case statement functions well currently and I drop it into the filter pane and select "AVG" and choose the correct number. This allows me to equally distribute the visualization across the axis. The statement is essentially this:
CASE [Business Unit]
WHEN "Business Unit 1" THEN
CASE [Current Reviewer]
WHEN "Person 1" THEN 1
WHEN "Person 2" THEN 2
WHEN "Person 3" THEN 3
ELSE 100 END
WHEN "Business Unit 2" THEN
CASE [Current Reviewer]
WHEN "Person 1" THEN 1
WHEN "Person 2" THEN 2
WHEN "Person 3" THEN 3
ELSE 100 END
ELSE 100 END
END
I'm now trying to add another dimension into it. The IF Statement would be something like:
If [Business Unit] is "Business Unit 1" AND [Work Area] is "Work Area 1" THEN
CASE [Current Reviewer]
WHEN "Person 1" THEN 1
WHEN "Person 2" THEN 2
WHEN "Person 3" THEN 3
ELSE 100 END
IF [Business Unit] is "Business Unit 2" AND [Work Area] is "Work Area 1" THEN
CASE [Current Reviewer]
WHEN "Person 1" THEN 1
WHEN "Person 2" THEN 2
WHEN "Person 3" THEN 3
ELSE 100 END
I tried this:
IF [Business Unit] = "Business Unit 1" AND [Work Area] = "Compliance" AND [Current Reviewer] = "Person 1" THEN 1
ELSEIF [Business Unit] = "Business Unit 1" AND [Work Area] = "Compliance" AND [Current Reviewer] = "Person 2" THEN 2
ELSEIF [Business Unit] = "Business Unit 1" AND [Work Area] = "Compliance" AND [Current Reviewer] = "Person 3" THEN 3
ELSE 100
END
This obviously worked for me until I tried to add a second Busisuness unit and it only showed the first. Is what I'm trying to do possible with a case statement? Please let me know your thoughts and ideas. I appreciate it.
What i really need to do is incorporate two things:
1) The ability to add "Work Area Level 2" to the calculation
2) Populate approvers with 0 invoices in their queue into the route with equal sizing on the chart
Thank you.
Best Answer
You can nest your CASE statement inside an IF statement:
IF [Business Unit] = "BU 1" And [Work Area Level 2] = "Area 1"
Then
CASE [Current Reviewer]
WHEN "Shary" THEN 1
WHEN "Shaunna" THEN 2
WHEN "Melissa" THEN 3
WHEN "Tucker" THEN 4
WHEN "Adam" THEN 5
ELSE 100 END
ELSEIF [Business Unit] = "BU 1" And [Work Area Level 2] = "Area 2"
Then
CASE [Current Reviewer]
WHEN "Shary" THEN 1
WHEN "Shaunna" THEN 2
WHEN "Bart" THEN 3
WHEN "Adam" THEN 4
ELSE 100 END
Else 100
END
I can't really figure out all the tricks you are using to get your presentation -- still learning, myself.
I'm wondering if you might use a dedicated data source with your name to order mapping on it to make it easier to maintain. That might also help with the problem with reviewers with no invoices.
Michael Johnston (Member) asked a question.
Hi, I'm trying to figure out how to change the default baby blue highlight color when selecting something in a row. I would ideally like to have all the colors in the workbook match the branding of the company and the baby blue just doesn't work with anything :)
I would really appreciate any help trying to turn the blue highlight into a red highlight color.
I have attached a workbook with the "List" tab being the tab I am trying to adjust the highlighting.
Best Answer
hi @Larry David
Interesting challenge! As far as I know there isn't an "out the box" way to do this. Attached is a way to do this using parameters and parameter actions. There is a decision here on whether "the juice is worth the squeeze" as you may need to change some other actions, and would be a lot of work to do it like this for all highlighting (but if only this selection box, then maybe not too bad)
Anyway hope this helps
Jusran Mawardi (Member) asked a question.
hi all,
I want to mask the sensitive data, so when users download the data, they sensitive information is masked. Let say I want to masking the name:
Name : TABLEAU SOFTWARE
Result : T****** S*******
Or
Name : AMAZON WEB SERVICE
Result : A***** W** S******
Or
Name : APPLE
Result : A****
the field has no specific how many spaces
the question is, how to find the first character in every word? so I can get the result as expected.
Note: for character "*", I try to use SPACE(N), and REPLACE(SPACE(N), " ", "*")
Best
Best Answer
Hi, Jusran
Please try my solution below
Hope this helps
ZZ
Dom Barry (Member) asked a question.
I have a dashboard with multiple bar charts.
I have set each bar chart to work as a filter by selecting 'use as filter'.
I now want to add a "reset all filters" button which impacts chart filters.
I have already:
* added a filter button
* added a filter action
* set the correct source sheets, target sheets & selected fields
When I test I use a chart to filter then press my reset button.
All the charts reset APART from the original one where the chart filter was selected are reset.
I am confused, I thought this would work.
What am I doing wrong?
Is there a solution?
Tony Fahd (Member) asked a question.
Hello, I am attaching a workbook that has a table with two columns. i like to resize one column independently from the second column in the table. but every time i try to resize the first column, the whole table will resize as well. any help is appreciated
Best Answer
There are 2 ways you can hide it:
Option 1: Resize it as shown in image:
Option 2:
Change the Marks to Circle and Color to White and size to zero.
Darin Friedrichs (Member) asked a question.
There are some old posts about this, but none seem to have any solutions so I wanted to ask again.
The problem I'm having is when exporting a dashboard to PDF the images/logos end up looking terrible, regardless of what resolution you use in the dashboard.
I've attached test.pdf as an example. The image file I'm using in the dashboard is a 1280 pixel high resolution Tableau logo, but when printing to PDF it ends up looking low-quality and pixelated. It looks pretty bad and I wouldn't want to send that out because it seems like I used a low-res version of the logo.
For comparison I've also attached test2.pdf which shows how it looks if I add the logo in after using Adobe PDF. This looks so much better, however this isn't a great solution because it's fairly manual.
Any ideas?
Wissam Kahi (Member) asked a question.
How can I use the tableau new Tableau 10 "Clustering" function on coordinates (latitude, longitude) to cluster together locations that are close to each other?
Context: I have a geo-spatial coordinates about ~2000 locations (stores) in North America. Some are isolated and others are fairly clustered together. I would like to cluster them in groups so that the ones that are fairly close to each other are clustered together (I expect to have ~200 clusters ranging from 1 store alone to ~20 stores within a ~30 miles radius). I tried the clustering function from the analytics tab and I tried to feed it my coordinates, but it did not accept them. I find it weird as the k-means clustering is inspired from euclidian distances originally. Any advice?
Please check out our post with some tips on asking a question and how to help you get answers more quickly.
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.