By William M —

Tableau: AFDB Market Trends with Viz. Part 1

Tableau: AFDB Market Trends with Viz. Part 1
Photo by Denis Shchigolev / Unsplash

I have embedded the visualization of the AFDB Market Trend dataset below. Tableau dashboards seem to work flawlessly on desktop, but often have trouble on mobile displays. I will include screenshots, and the direct link to the dashboard on Tableau Public can be found here.

This is an example of the dashboard, if it looks very different (or doesn't load below this image at all) it may be better to try another browser.
I started my dashboard with a draft. It is a single line graph that allows the end user to choose which data and time-frame they want to examine... it was a draft that was never meant to share on the internet... so don't judge.

In order to turn this draft into a working dashboard I considered a few steps then began to create the table.

  1. I imported data and made sure the data types were correct.
  2. I placed the 'date' variable in the columns, and the 'value' as the rows.
  3. On the Graph itself I placed the 'Indicator Name' as I wanted to be able to display each indicator's value's separately as opposed to aggregating the value for all indicators.
  4. I created a filter for indicator name, so the user can choose which indicator(s) they would like to see.
  5. The SUM(value) was changed to average (for future aggregations, by month or quarter, etc)
  6. A calculated field was created to filter out commodities (
IF ISNULL([Unit]) THEN 'Main Indicators'
ELSE 'Commodity Indicators'
END
  1. Make sure the indictor filter is affected by the 'commody indicator', else it will show all the indicators even when just 'commodies' or just 'Main indicators' is selected.

Before:

Previous

SQL EDA - AFDB Market Trends - Part 2

 Next

SQL/Tableau: AFDB Market Trends with Viz. Part 2