In this tip, I show you how to use a calculated field to always sort a specific dimension to the bottom of a chart. You can also always have a dimension at the top, you simply change the sort from Descending to Ascending. This also works with column charts that sort left-to-right.

We've all answered Likert scale questions. These are questions like "How likely are you to recommend our product?" and they are typically on a five point scale (e.g., from not at all to very highly likely).

In this video, I show you how to visualize Likert scale data and how to include a Net Promoter Score (NPS). To get the data that I used, simply download the workbook and unzip it. You will then see a folder named "Data".

Useful links:

1. What is a Likert Scale? http://bit.ly/LikertSurveyMonkey

2. What is a Net Promoter Score? https://www.netpromoter.com/know/ 

Christmas...it's supposed to be the most wonderful time of the year, at least that's what the song says. Coincidentally, for week 38 (Dec 21-17), the topic was negative thoughts. Given the level of stress that I felt all week, I'm actually happy this was the topic because it helped me understand what and who was "causing" my negative thoughts.

I tracked the date, what was on my mind, the general topic, where I was, who I was with, the stress level and what I was doing.

I tend to always look at what Giorgia and Stefanie produce each week as a way of looking for inspiration. This week, I really liked how Stefanie created piles for her negative thoughts.

Stefanie included a classification of inward/outward for each negative thought then split them up so you could see how much more there was on one side vs. the other. So I went back to my data and added a similar classification. More on this in a minute.

Here are some of the highlights from the data analysis I performed on my data:

1. My inward negative thoughts more than doubled my outward negative thoughts. This means that I was keeping my negativity to myself more than expressing it to others. For me, this is good because I have always tended to just say whatever is on my mind. Does this mean I am learning to control myself a bit more?
2. Most of the negative thoughts were me by myself. Otherwise, Beth was second most involved. This really isn't surprising given it was Christmas week, we went shopping together, and every year I get stressed about how much we spend on Christmas.
3. 75% of my negative thoughts were low stress...phew!!

Explore the entire week in the Tableau story below, including my thought process for how I decided which data to put in the final viz.