EDUCBA

EDUCBA

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

Tableau Order of Operations

By Priya PedamkarPriya Pedamkar

Home » Data Science » Data Science Tutorials » Tableau Tutorial » Tableau Order of Operations

Tableau Order of Operations

Introduction to Tableau Order of Operations

The order of operation is about the order of execution in tableau. When we perform certain queries or operation there is a pipeline through which query gets executed. The operation such as create different types of graph, apply filters such as color, size, text, create calculation fields, create the view, etc. There is a procedure to produce results as a filter or view, tableau cannot produce anything you want. Data gets manipulated while performing any operation. When we get to know each level of detail about the process it will be an advantage for users. There is always an advantage of understanding every level of operation in tableau.

How to do an Order of Operation in Tableau?

We are going to show the flow of filters in tableau. Each filter has its own values or way to work with tableau data. Extract filter is used for extracting data file, it can be present in forms like excel, text, online server, JSON file, etc. A data source filter is for extracting data sources such as file dragged to, the table gets created into data source sheet. Context filter contains filters such assets, conditional filter, top N, these would be used for finding value from the context. Dimension filter contains data blending which is used for combing two axes into one which will give us more certainty of the data. Measure filter is used for measure value such as the forecast of temperature, weather or table calculation we can create a calculated field for the numeric data. Table calculation filter contains a trend line and the reference line will provide insight into the data and will highlight trends in data.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

trends in data

Examples to Implement Tableau Order of Operations

Below are the examples:

Example #1

We will work with the context filter and will see how this filter will help us to speed up the query performance and result of the data. We will convert the dimension filter to the context filter.

  1. Open the tableau desktop or public version.
  2. Open sample superstore dataset or you can use the dataset of your choice (from tableau site you can get n number of the different dataset). This is nothing but the extract filter.
  3. Drag the order table into the data source filter.
  4. Drag sales measure to columns
  5. Drag customer Name dimension to
  6. Drag city dimension to
  7. Drag city to Filters -> click on none ->select New York City (you can select of your choice).
  8. Drag customer name to Filters -> click on Top -> select By Field as Top

When you click on Top 10 you will get to see the result as only 5 results because Top and dimension filter is applied simultaneously. Now add context filter to the city filter.

Top and dimension filter

  1. Right-click on city Filter -> select add context You will get to see the result as Top 10 customer as per the sale.

Top 10 customer

Examples #2

We are going to show the profit as per the state and product name.

  1. Drag profit measure to
  2. Drag product name and state dimension to
  3. Drag product name to filters and select some of the
  4. Drag state to filter -> go to the Top -> click by field and select the top
  5. Click on product name -> select add to the

When will add context view, measure color will get changed. You can see the color of Product Name.

measure color

Example #3

  1. Drag sales measure to columns.
  2. Drag sub-category and city dimension to
  3. Drag the city and sub-category to
  4. Select the city like Los Angeles from
  5. Sub-category from Filters -> go to Top -> select By
  6. Add context filter to the city. Click on the city ->add to the context

Tableau Order of Operations - 5

  • If we select two or three sub-categories from filter then the result will be different, it might show the top 10 or less than 10.
  • You can observe in the below image we have selected sub-category as Accessories, Appliances, Machines, and Paper. We can observe that the limit is set to 10.
  • But we are not getting the top 10 results because selected categories have less than 10 data assign to.

Tableau Order of Operations - 6

Conclusion

We have learned about the order of operation in tableau. Sometimes we don’t get the result as expected because there is a pipeline of executing tableau function. We don’t get through it then we are getting results as an error. It is always god to follow the order of operation which will simplify the execution of the tasks or operation performed.

Recommended Articles

This is a guide to Tableau Order of Operations. Here we discuss an introduction, how to do an order to operate and examples to implement for better understanding. You can also go through our other related articles to learn more –

  1. Pie Chart in Tableau
  2. Sets in Tableau
  3. Dashboard in Tableau
  4. Tableau Action Filter
  5. Guide to Tableau User Group | Example

All in One Data Science Bundle (360+ Courses, 50+ projects)

360+ Online Courses

50+ projects

1500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Tableau Tutorial
  • 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
  • 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
  • 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
  • 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
  • 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 Certification Course Learn More