EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login

Tableau Fixed Function

By Priya PedamkarPriya Pedamkar

Home » Data Science » Data Science Tutorials » Tableau Tutorial » Tableau Fixed Function

Tableau Fixed Function

Introduction to Tableau Fixed Function

Tableau fixed function is used to aggregate the values present at dimensions only in the specified calculation field. The fixed-function does not take the view into consideration while the aggregating value for category type values. A fixed view is created refereeing to dimensions existing in the current view. Fixed calculations are on the top priority for the order operation. This will provide the level of details of the dimensions. It is not depending on what visualization we have in the tableau or we don’t have in the tableau. We can simply fix the level of details we want to display in the tableau.

Syntax

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Fixed(subject):SUM(subject)

The subject is nothing but the dimensions aggregation, the sum of the value. It is the group by sum or sum of the value.

{FIXED [Subject] : [Q1 %] }

Select the subject and Q1 % is the SUM of the group by subject.

Data is aggregated at a different level and fixed value changes as per the values or data changes. The calculation field is important while aggregating values.

How to Use Tableau Fixed Function?

  • Start Tableau Public or Desktop edition.
  • Drag superstore datasheet or you can add data sheet as per your choice (you can download sample datasheet from tableau official site).
  • Click on connect to data to open datasheet.

Tableau Fixed Function 1

  • Click on text file open->open file from your computer.
  • The below image will appear.

Tableau Fixed Function 2

  • Go to sheet 1, data gets allocated into Dimensions and Measures. You can observe into the below dimensions (qualitative) like country, item type a measure (quantity) like unit cost and unit sold, etc.

Tableau Fixed Function 3

The FIXED function is used for finding specific value for the category.

  • Go to the down arrow at dimension-> click on create a calculated field.

Tableau Fixed Function 4

  • Type calculation formula we want. To aggregating the values.

{ FIXED [Country],[Region]:SUM([Total Profit])}

Tableau Fixed Function 5

  • We can see a Fixed calculated field in the measures.

Tableau Fixed Function 6

  • Drag Measure names into columns and country into rows, measure names into filters, measure values into Text filter. You can see the fixed value for each country. Each fixed value is identical for each country.

Tableau Fixed Function 7

Example of Tableau Fixed Function

We will find out the sum of sales as per the region, we are referring to sample superstore data file. We have downloaded from Tableau Community forum.

Sum of sales as per region

  • Download the sample superstore file and save it to the computer.
  • Open Tableau Public or desktop version.
  • Open sample super store file from computer.

Tableau Fixed Function 8

  • When you click on Connect to data, you have shown multiple options to open the file you want.
  • When you open a sample superstore file you will get to see three different databases.
  • We have chosen the Orders table and drag it to the Data Source sheet.

Tableau Fixed Function 9

  • We will get to see data arranged into different fields as per it is the data type.
  • Go to sheet (I have given name as sales)
  • Create a calculate filed named sum of sales and add details.

{FIXED [Region]:SUM([Sales])}

  • Drag region and state dimensions to rows.
  • Dra region to Color formatting option and Drag sum of sales to Text formatting option.

Text Formating Option

  • We can observe in the above image, the sum of sales as per region is the same for a different state, that is value is fixed for all the state comes under the region.
  • We can see that for the Central region the sum of the sale is 501204.
  • We can filter the region by dragging the region to filter the formatting window.

formatting window

  • We can see the sale as per the East region.

East region

Sum of profit as per state with sub-category

  • Create calculated field with details {FIXED [State]:SUM([Profit])}
  • Drag State and sub-category to rows.
  • State into color formatting option and profit by state into Text formatting option.

color formatting option

  • We can observe that profit for sub-category like accessories, art, labels, phone, etc that comes under Alabama state is 5,787.
  • We can observe that we have a large number of state and subcategory options available, we will add state and sub-category to Filters and select less number of states so that we can get to see the result about different state also.

state and subcategory options

  • We can observe in the below image, sub-category for each state and profit values. We are seeing limited sub-categories like Appliances, Bookcases, Envelopes, and Labels.

limited sub-categories

Conclusion

we have learned about FIXED function in tableau, as per the name of the function it works in the same way. We have seen some examples of fixed-function such as the sum of sales as per region and sum of profit as per state which shows us that fixed value will not change for different Fixed values given in the formula.

Recommended Articles

This is a guide to Tableau Fixed Function. Here we discuss How to Use Tableau Fixed Function along with the Examples. You may also have a look at the following articles to learn more –

  1. Dashboard in Tableau
  2. Group in Tableau
  3. Concatenate in Tableau
  4. Map Layers in Tableau
  5. Guide to Window Sum Tableau

Tableau Training (4 Courses, 6+ Projects)

4 Online Courses

6 Hands-on Projects

39+ Hours

Verifiable Certificate of Completion

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Tableau Tutorial
  • Functions
    • Tableau Functions
    • Tableau String Functions
    • Concatenate in Tableau
    • Rank Function in Tableau
    • Tableau Aggregate Functions
    • Tableau Date Functions
    • Window Sum Tableau
    • LOD Expressions in Tableau
    • LOOKUP Function in Tableau
    • Tableau Fixed Function
    • Tableau Count Distinct
    • Tableau Window Functions
  • Basic
    • What is Tableau
    • What is Tableau Dashboard
    • What is Tableau Server
    • Uses of Tableau
    • Tableau Versions
    • Tableau Architecture
    • Is Tableau Free
    • Tableau New Features
    • How To Install Tableau
    • How to Use Tableau?
    • Install Tableau Server
    • Tableau Commands
  • Charts
    • Tableau Charts
    • Tableau Chart Types
    • Donut Chart in Tableau
    • Funnel Chart in Tableau
    • Gantt Chart in Tableau
    • Bubble Chart in Tableau
    • Pareto Chart in Tableau
    • Sankey Chart In Tableau
    • Stacked Bar Chart in Tableau
    • Tableau Bullet Chart
    • Waterfall Chart in Tableau
    • Line Chart in Tableau
    • Heat Map in Tableau
    • Histogram in Tableau
    • CrossTab in Tableau
    • Treemap in Tableau
    • Trend Lines in Tableau
    • Tableau Reference Lines
    • Tableau Dual Axis
    • Legend in Tableau
    • Pie Chart in Tableau
    • Tableau Storyline
  • Statement
    • Tableau IF Statement
    • Case Statement in Tableau
  • Sort/Filters
    • Sorting in Tableau
    • Filters in Tableau
    • Types of Filters in Tableau
    • Tableau Action Filter
    • Context Filter in Tableau
    • Tableau Parameter Filter
    • Adding Filters in Tableau Dashboard
    • Tableau Context Filter
  • Tableau Dashboard
    • Dashboard in Tableau
    • Tableau Dashboard Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Advanced
    • Tableau Reporting
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • Tableau Drill Down
    • Tableau Dynamic Parameters
    • Tableau Table Calculation
    • Tableau Visualization
    • Tableau Joins
    • Pivot in Tableau
    • Data Visualization With Tableau
    • Forecast in Tableau
    • Map Layers in Tableau
    • Group in Tableau
    • Tableau Group by
    • Hierarchy in Tableau
    • Sets in Tableau
    • How to create a Set in Tableau
    • Tableau Order of Operations
    • Tableau User Group
    • Tableau Calculated Field
    • Custom SQL in Tableau
  • Interview Questions
    • Tableau Interview Questions

Related Courses

Tableau Certification Course

Business Intelligence Courses

Data Visualization Courses

Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

© 2020 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA Login

Forgot Password?

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you
Book Your One Instructor : One Learner Free Class

Let’s Get Started

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

Special Offer - Tableau Training (4 Courses, 6+ Projects) Learn More