How to do Reverse Normalization?

employees in white long sleeve shirt busy working inside an office

Tableau is a powerful data visualization tool that allows users to create interactive and engaging visualizations from a wide range of data sources. One of the key features of Tableau is its ability to perform normalization, which is a method of scaling data to make it more comparable across different dimensions. However, sometimes it’s necessary to do the opposite, and reverse the normalization to bring the data back to its original scale. In this article, we will explore how to do reverse normalization in Tableau.

Keep on Reading: Tableau Data Analyst Certification Questions »

Tableau Reverse Normalization
Tableau Reverse Normalization

Desktop Specialist

Learn more about Desktop Specialist Certification.

Data Analyst

Learn more about the Data Analyst Certification.

Server Certified

Learn more about the Tableau Server Certification.

Ready to contribute to the Tableau community? Get $30 for sharing your work and certification experiences. Write and get paid for every article. Learn more »

  1. Understanding Normalization – Normalization in Tableau is a process of scaling data to make it more comparable across different dimensions. This can be done by dividing the data by a specific value, such as the sum of all data points or the maximum value. Normalization is often used to make data more interpretable, especially when working with large data sets.
  2. Reversing Normalization – To reverse normalization in Tableau, you will need to multiply the normalized data by the value that was used to divide it. For example, if you normalized data by dividing it by the maximum value, you will need to multiply it by the same value to reverse the normalization.
  3. Create a Calculated Field – The easiest way to reverse normalization in Tableau is to create a calculated field. To do this, go to the “Analysis” menu and select “Create Calculated Field.” In the formula editor, enter a calculation that will reverse the normalization, such as “SUM([Sales])*[Normalized Sales].”
  4. Use the Reversed Normalized Data – Once you have created the calculated field, you can use the reversed normalized data in your visualizations. You can drag the calculated field onto the appropriate shelf, such as Columns or Rows, and use it to create new visualizations or update existing ones.
  5. Use the Original Scale – If you want to use the original scale instead of the normalized one, you can simply drag the original field to the visualization instead of the calculated field that you created.

Keep reading: Tableau Desktop Specialist Certification Questions »

Loading RSS Feed

In conclusion, normalization is a useful method of scaling data to make it more comparable across different dimensions, but sometimes it’s necessary to reverse the normalization to bring the data back to its original scale.

Get our Most Popular Downloads

Download the most popular scenario-based Tableau Workbooks in .twbx format. Used by thousands of Tableau developers and job aspirants every day to improve and fine-tune their CV and Tableau Public profile. Join the largest Tableau Experts Social Group.

Tableau Banking and Financial Dataset Analysis Download
Banking & Financial Dataset Analysis

Financial Domain Tableau Dataset and Analysis. The most important domain in today’s industry. Analyze Key Performance Indicators. Discover Risky and Fraudulent Outliers. Download the Tableau Packaged (.twbx) Workbook. Includes a complete Financial dataset analysis. Enhance your Data Analytics experience with our skilled analysis.

Tableau Healthcare and Hospital Dataset Analysis Download
Healthcare & Hospital Dataset Analysis

Hospital and Healthcare Domain Tableau Dataset and Analysis. A key field of study with millions of lives at stake. The most sensitive industry today. Download the Tableau Packaged (.twbx) Workbook. Understand how healthcare datasets work. Includes a complete Healthcare dataset with analytical charts. Explore Tableau interactive features with this download.

Tableau Insurance Dataset Analysis Download
Insurance Dataset Analysis

Insurance Domain Tableau Dataset and Analysis. Important domain specific metrics and data. Learn how to visualize important metrics. Show outliers and insightful data points. Download the Tableau Packaged (.twbx) Workbook. Includes comprehensive analysis of Insurance data of a large sample population. Uses industry standard analytical practices.

Tableau Practice Test

The best Tableau practice exams built. Period. Explore definitive practical problems created by brilliant Tableau experts.

Get in Touch

Contact Us
Write for Us

Published by Rahul Bhattacharya

Rahul is a journalist with expertise in researching a variety of topics and writing engaging contents. He is also a data analyst and an expert in visualizing business scenarios using data science. Rahul is skilled in a number of programming languages and data analysis tools. When he is not busy writing, Rahul can be found somewhere in the Appalachian trails or in an ethnic restaurant in Chicago.

Leave a Reply