Tableau Tips: Using data formatted for other countries in Tableau
This weeks #MakeoverMonday features data in values from the United Kingdom, where date format and currency value are measured and recorded differently. I noticed on Twitter and the data.world post that there was some discussion on how to prep the data to handle in Tableau.
When working with these different values, there is no additional prep work required in Excel, Tableau Prep, or other tools. With the simple change of a few formatting fields, you can have Tableau work correctly with these data fields out of the box.
The dates are not all from January of the year, but are instead formatted in DD-MM-YY. Additionally, we know that the Gross Value Added is in GB pounds, based on the article discussing these findings on the data.world page.
To adjust these values, right-click and edit the date to DD-MM-YY and set a standard currency to English (United Kingdom).