Making Formula Editor More Visual
Currently a formula in Tableau can look plain and a bit boring:
I would suggest highlighting the syntax words like Case, When, Then, End etc.
#TweakThursday 14: Dotting The Map
This Monday's Viz of the Day (8/22/2016) is about malaria in Africa. This topic is dear to me in two ways:
- Last year in 2015, the Nobel Prize in Medicine was given to Ms.Youyou Tu of China for discovering artemisinin and dihydroartemisinin, used to treat malaria, which saved millions of lives.
Counting Customers Who Bought The Same Products
I wrote previously a post on how to count customers who bought both A and B. Today someone asked how to count those who all bought the same N items. N>=2. He specifically requires a multiple choice filter so that people can select some items and only those who bought them all are showing.
8#TweakThursday 13: Debugging Visually
A viz is a piece of application software that has data as input and graphics as output. In between we created a flow of logic. We may have all experienced buggy software in our life. It is part of the human nature that we have imperfections which are reflected in our creations.
Embedding Tableau Public in a Web Page
From a thread in Linkedin's Tableau group and the included blog and viz, I found that people may not know how to correctly embed a Tableau Public viz in a web page. There are a few blog posts on embedding. But the Tableau Public has evolved and some new features are not covered. So here is my post.
10Cloning a Data Connection in Tableau
This may be obvious to others, but not to me. Only up to recently, I had to
- Click Add a New Data Source
- Refill server address, port number, database name, username, password
so that I can connect to a data source that I already have.
#TweakThursday 12: Likert Scale in Tooltips
What is Likert scale? Here is the explanation.
Here is the wiki page on Likert Scale. Tableau Zen Master Steve Wexler is an expert on Likert scale visualization.
Today's Viz of the Day (8/10/2016) includes some survey data. It results from a simple yes-or-no Likert scale survey.
Labeling Inside Pie Chart
Tableau's default labeling of Pie chart is outside of the pie. But some may prefer to put the labels inside, which is not obvious.
There are 3 ways to do it, depends on what you need.
#TweakThursday 11: Sort by Quantity Descendingly
Sorting data is always a must for presenting information. Data in disorder is of little value. Especially for data analysts, part of our added value is to put data in order.
Sort by what? In what order?
There are various dimensions to order by.
Lookup by Association
There came a question regarding "Lookup via Association". I have seen similar questions a while ago. I almost forgot how I solved them before. This time I will write it down.
Problem Statement
Given a customer who is from some state(s).