Posts Tagged ‘graph’

Tableau Candlestick Chart

October 10th, 2013 No comments

Recently I’ve had reason to pay more attention to the stock of who are the company that introduced me to Tableau. They implemented Tableau Server a few years ago while I was in a very small team of analysts working there at the time, enabling me gain the level of expertise I now have. While analysing the performance of their stock I’ve begun to gain a new appreciation for the candlestick chart and thought about creating this chart in Tableau.

I downloaded the daily stock data for the past 2 years from the Nasdaq website and found a very useful tutorial on the Tableau site about how to create a candlestick chart in Tableau. This saved me many hours of working out how to do this and now I’m going to write it up step by step on this site.

The downloaded dataset is very simple, it contains the date, open price, close price, day high, day low and the volume. I added the ticker to this as well, although unnecessary if only looking at one stock. This can be used as a filter should you load a number of different stocks into the same chart. Tableau should automatically assign the correct data type to the dimensions and measures, they should appear as follows:

Read more…

Tableau Filter the data on display and not the underlying data

May 16th, 2012 No comments

I was recently set a challenge to filter a chart based on something that happened in the past, but still to show all time periods. The specifics of the task was to look at the number of employees a company had in 2010, and depending on that amount either show or hide all years for those companies that had the right amount of employees. In other words create a ‘Number of employees in 2010’ filter.

The dataset contained only 3 fields, Company, Year and Employees.

Initially it seems simple. Create a calculated field to calculate the number of employees the company had in 2010 and use that as a filter. This is what I did, the field was called [2010 Employee Count] and the formula I used was SUM(IF [Year] = 2010 THEN [Employees] END). Next I had to set up the visualisation to test what I created worked.

I dragged the Year to the columns shelf, Employees to the rows shelf and summed it, the Company to the colour shelf, giving me a line graph with annual employee counts over time split by company. This gives me the following line chart:

Next I tested the filter by dragging the calculated field [2010 Employee Count] to the filter shelf and using the At Least filter to show all companies with over X employees in 2010. This is where it became evident that this wasn’t going to work – the filter affected the entire dataset and not only the selected companies as can be seen below: Read more…

Waterfall Charts in Tableau

March 8th, 2012 No comments

I’ve noticed waterfall charts are becoming quite fashionable now. If you’re not sure why this is used, it’s a great way, for example,  of showing how total revenue is compiled from it’s components. Using the Tableau Gantt Chart it’s quite simple to build. In this article I’ll give a very quick guide to building your own such as the chart below.

Read more…

Bullet Charts in Tableau

February 5th, 2012 No comments

I’ve only just discovered the bullet chart, I’ve had no need to create one until very recently. Both I and my customers find them really useful. They replace the less meaningful ‘traditional’ dashboard tools of guages and dials into something which conveys more information.

The purpose of using them is to compare a value against another value – for example sales this year vs sales last year or order count this year vs budget order count. It compares against the Total of 1 value and the percentiles of that total. In other words it can be seen at a glance if this year is ahead of last year, or to what percentile this year has reached against last year. Read more…

Create a chart in seconds using Show Me in Tableau

October 8th, 2011 No comments

One of the most powerful features of Tableau to a newcomer and those who aren’t sure how to display their data is the Show Me! button. Even as an experienced user I often use the Show Me in Tableau when I’m seeking inspiration as to the best ways to display the information in the dashboard.

To create a visualisation all that needs to be done is highlight the dimensions and measures to display by clicking on them while holding the ctrl key, click the Show Me! button and you have a visualisation. Simple as that.