title: How to create a Normalize Graph (Min Max Normalization) on Tableau
body: <p>I'm a newbie in Tableau. Data looks like that. I want to do Min Max Normalization.</p>
  <pre><code>Date            BU     BU Sub       Balance
  03/30/2020     PBB  Construction    123,541
  02/29/2020     CB      Land         9,801,312 
  10/31/2019     REB     Finished     123,125,553
  06/30/2018     PB     CRE           123,125,553
  ..... 
  </code></pre>
  <p>The min max normalization formula is: (x - min(x)) / (max(x) - min(x)) so I tried:</p>
  <pre><code>(ZN([balance]) - {FIXED: MIN(ZN([balance]))})
  /
  ({FIXED: MAX(ZN([balance]))} - {FIXED: MIN(ZN([balance]))})
  </code></pre>
  <p><a href="https://i.stack.imgur.com/IoJWO.png" rel="nofollow noreferrer">Min Max Normalization Graph</a></p>
  <p>I got a graph but I am not sure if it's normalize because I want growth in % by BU. And the y-axis number got so huge. In this formula, it should be in % but
  the lowest number in the calc is 336. Does this mean it's 336% growth?</p>
  <p>How do I make it more readable / interpret? Also, is this formula correct for doing Min Max Normalization? If not, what are other ways to do it on Tableau?</p>