Normalize Values - Tableau

0 votes
I want to normalize values for the sales all over region wrt to a constant value. Do i use calculated field or is there any function in Tableau?
Apr 23 in Tableau by Apoorva
28 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Hi Apoorva,

There is no function to normalize value in Tableau.

Use a calculated field to normalize the field values with value as 

Normalized value = [field name]/ value or DIV([field name],value) with DIV() function

Now add the created field in sheet, to get normalized value.

Hope this helps you.

answered Apr 23 by CHERUKURI
• 12,780 points

Related Questions In Tableau

0 votes
1 answer

Using Regex in Tableau, but only getting Null values.

Tableau regex engine is ICU, and there ...READ MORE

answered Aug 17, 2018 in Tableau by AwesomeSauce
• 830 points
25 views
0 votes
1 answer

Search values in a sheet for a field and display in tableau

Hi Sindhu, Follow below steps: 1. Create a parameter ...READ MORE

answered Apr 3 in Tableau by CHERUKURI
• 12,780 points
32 views
0 votes
1 answer

Changing filter values based on parameter selection - Tableau

Hi, I will show you an example ...READ MORE

answered Apr 4 in Tableau by CHERUKURI
• 12,780 points
24 views
0 votes
1 answer

Return rows with not null values in Tableau

Hi Nithin, You can add a calculated field ...READ MORE

answered Apr 10 in Tableau by CHERUKURI
• 12,780 points
38 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,190 points
901 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,190 points
35 views
+2 votes
1 answer
0 votes
1 answer

Rank measure values and show percentage of measures in Tableau

Hi Sindhu, 1. First create a table with ...READ MORE

answered Mar 8 in Tableau by CHERUKURI
• 12,780 points
33 views
0 votes
1 answer

Tableau- Pie Chart with Multiple Measure Values

Hi Nithin, Pie chart is used to show ...READ MORE

answered Mar 11 in Tableau by CHERUKURI
• 12,780 points
97 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.