Data Viz Done Right

November 8, 2017

Workout Wednesday: Stock Portfolio

2 comments
For #WorkoutWednesday week 45, your challenge is to build this new style of visualising a stock portfolio. This idea came from Jeffrey Shaffer, which was a fun challenge to rebuild, and for your challenge, you will have to work with a bigger data set.

Here's what you need to do:

  • Download the data here. You will most likely need to do a bit of data prep like pivoting, at least I needed to.
  • Match the title
  • Match the legend
  • Match the tooltips
  • The black bars represent the 52-week low and 52-week high for each stock and the text below each bar also shows these values.
  • The blue dot represents the latest price.
  • Size should be 375x667 to fit on a mobile device. If it doesn't display properly on my phone, then it's not right. Use Device Designer.
  • Rebuild everything to look identical to mine.

Good luck!

2 comments :

  1. Hi Andy,

    I am not sure what I am doing wrong- I downloaded your Viz as well as the data set & got to work. I pivoted Adj Close, Close, High, Low, Open, and Volume. And renamed Pivot Field Names to Metric and Pivot Field Values to Value. Then created the calculated fields for the values of the metrics. All very simple.

    I like to check my numbers periodically to make sure everything is adding up, and my calculated fields for the metrics are off- about 6x that of yours. For example, I am getting a sum of 3,546,928 for 'High' while yours is 645,369. Additionally, I checked to make sure there were no filters/default aggregation/number format differences in our workbooks while I was checking these numbers. The only thing I can think of is there are 6 Metrics (Adj Close, Close, High, Low, Open, and Volume) so maybe there is some correlation there?

    I appreciate your time and thank you for helping us grow in our Tableau Skills.

    ReplyDelete
    Replies
    1. Have you compared your calculations to mine? It sounds like the filtering inside the calc might not be quite right, but it's hard to tell given the details you provided.

      Delete