2 Replies Latest reply on Feb 22, 2018 9:19 PM by Indrajeet Kuam

    Normalizing the data in Tableau

    Indrajeet Kuam

      Hi everyone,

      I need help in normalizing the data I have. Plaese help me in calculation as I don't know the right method to do it.

       

      Below is the snapshot of my data.

         

      Product IDMonthSales UnitSales(in thousands)Profit
      1001Jan-1728848348
      1001Feb-176831502202
      1001Mar-1739165265
      1001Apr-1739566467
      1001May-1726744845
      1001Jun-1747379479
      1001Jul-1726744845
      1001Aug-1736561361
      1001Sep-1739767368
      1001Oct-1730250951
      1001Nov-1726744845
      1001Dec-1735960460
      1002Jan-1715425926
      1002Feb-175601239168
      1002Mar-1739567168
      1002Apr-1723138939
      1002May-1719532833
      1002Jun-1728648148
      1002Jul-1715425926
      1002Aug-1719532833
      1002Sep-1723138939
      1002Oct-1718030230
      1002Nov-1716928529
      1002Dec-1727045446

      I want to normalize this data. I have done it in Excel.

      Calculation steps in Excel: For Sales in months for a unique Product ID, finding the maximum and minimum and using sales- min(sales)/ max(sales)-min(sales).

      The desired final output is like this.

         

      Product IDMonthSales UnitSales(in thousands)Profit
      1001Jan-170.0500.0330.022
      1001Feb-171.0001.0001.000
      1001Mar-170.2970.1940.126
      1001Apr-170.3080.2050.137
      1001May-170.0000.0000.000
      1001Jun-170.4950.3280.220
      1001Jul-170.0000.0000.000
      1001Aug-170.2350.1560.104
      1001Sep-170.3120.2130.148
      1001Oct-170.0850.0570.038
      1001Nov-170.0000.0000.000
      1001Dec-170.2220.1480.099
      1002Jan-170.0000.0000.000
      1002Feb-171.0001.0001.000
      1002Mar-170.5940.4210.299
      1002Apr-170.1890.1320.091
      1002May-170.1020.0710.049
      1002Jun-170.3260.2270.159
      1002Jul-170.0000.0000.000
      1002Aug-170.1020.0710.049
      1002Sep-170.1890.1320.091
      1002Oct-170.0640.0440.030
      1002Nov-170.0380.0260.018
      1002Dec-170.2850.1990.140

      Please, help me create the same in Tableau.

      Thank you.