4 Replies Latest reply on Feb 19, 2019 5:46 AM by Caitlyn Garger

    Normalization/Standardization

    Caitlyn Garger

      The attached workbook was made using Tableau Desktop 2018.3.3.

       

      Hello!

       

      I have the following dashboard idea where I want to show import vs export values (in $) for certain commodities that the US trades:

      What I really want to see is any large changes/fluctuation in the import or export values throughout the years. I know that (for example) oil exports have increased significantly since 2008 as shown here:

       

      but you can't really see that trend on the dashboard because the values of imports has decreased dramatically as well.

       

      I was wondering if there was any way to normalize/standardize these scales so that I could see significant drops/increases for each commodity. Or if there is a better way to show that idea I'm open to that as well.


      I would really love any insight/guidance on this!

       

       

      Much appreciated,

      Caitlyn