{"id":11604,"date":"2018-03-23T12:19:33","date_gmt":"2018-03-23T12:19:33","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=11604"},"modified":"2025-03-01T21:46:20","modified_gmt":"2025-03-01T16:16:20","slug":"table-calculation-in-tableau","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/","title":{"rendered":"Table Calculation in Tableau – Calculation Function"},"content":{"rendered":"

This Tableau Table Calculations tutorial, we explained what is Tableau Table Calculations advanced functions and their uses. It also demonstrates how to create a table calculation in Tableau using the calculation editor.<\/p>\n

What is Table Calculation in Tableau?<\/h3>\n

Table Calculation in Tableau<\/strong> <\/a>is the counts which are connected to the qualities in the whole table. For instance, for figuring a running aggregate or running normal, we have to apply a solitary technique for a count to a whole segment. Such computations can’t be performed on some chose lines.<\/p>\n

Types of Calculation in Table Calculation<\/h3>\n

These are some important\u00a0Table Calculation in Tableau, we discuss them one by one:<\/p>\n

a. Percent change from a reference date<\/h4>\n

With table calculations in Tableau, you’ll be able to calculate the p.c amendment from an associate discretionary price. Suppose you’re inquisitive about a portfolio of stocks and need to gauge the relative performance of them from a degree in time. To do this, you would like to line associate \u201cinvestment date\u201d and normalize them to an equivalent purpose in time, with lines showing share amendment. You modify the reference date victimization the slider.<\/p>\n

\"Table<\/a><\/p>\n

b. Common baseline (Toy Story)<\/h4>\n

You may need to examine information from a standard place to begin instead of over associate absolute timeline. As an example, here area unit the box workplace receipts for the 3 Toy Story movies. It\u2019s a lot of easier to match them if you look into gross receipts by week since the gap date:<\/p>\n

\"Tableau<\/a><\/p>\n

c. Percent-of-total sales over time (multi-pass aggregation)<\/h4>\n

It’s common to need to perform 2 Tableau table calculations right away. As an example, it may be fascinating to examine however a phase has big or shrunken in importance to the corporate over time. To do this, you want to 1st cipher running add of sales by phase over time, then look into that as a p.c of all sales over time. This is conjointly referred to as multi-pass aggregation and it can be eluded even writing a formula in Tableau.<\/p>\n

\"Tableau<\/a><\/p>\n

d. Protective ranking even whereas sorting<\/h4>\n

Here we’d like to examine the rank of a product at intervals a month and year, then show however its ranking changes across time. To realize this, we tend to produce a bump chart, that shows amendment over time as a line chart. On the left, we are able to see however copiers and fax machines have gone from a poorly acting product to presently being out the third largest vendor. We are able to conjointly see that there has been plenty of volatility within the purchase of fax and apparatus machines.<\/p>\n

\"Table<\/a><\/p>\n

e. Running total<\/h4>\n

You need to watch the number of active support cases at your call center, or stock on shelves. However, the system doesn\u2019t record the rolling total of active cases and you would like to derive it. This can be adequate to # of Cases at Day Open + New Cases + Reopened Cases \u2013 Closed cases.<\/p>\n

On the surface, this can be an easy calculation. However, the daily gap position springs from the previous day shut, which, in turn, springs from that day\u2019s gap position. This creates a circular reference of calculations.<\/p>\n

\"Tableau<\/a><\/p>\n

f. Weighted average<\/h4>\n

Data like check scores or order priority lends itself to an analysis by weighted average. Maybe you’re gazing the common priority of all orders across product varieties and need to weight that priority by order volume, in order that higher-volume product receives the next priority score. You would possibly use that weighted average priority score to optimize you provide chain for high-volume, high-priority product. Here we tend to just do that victimization Superstore sales data:<\/p>\n

\"Tableau<\/a><\/p>\n

g. Grouping by a calculation<\/h4>\n

If you area unit managing a company’s shipping operations you will have an interest in which products\u2019 shipping prices are beyond average. In Tableau six, you’ll be able to cipher the common across a window and use that in a very calculation to cluster and color values.<\/p>\n

\"Table<\/a>

h. Variety of incidents over a moving very<\/span><\/p><\/div>\n

Diverse situations like retail, intelligence, or border management usually involve the number of times an occurrence has occurred at intervals a window. As an example, one suspicious event could also be an associate anomaly, however, if it happens quite n times in x days, then it warrants investigation.<\/p>\n

\"Tableau<\/a><\/p>\n

The dots show the number of times associate alert or the alarm has been raised \u2013 usually zero. A dot higher than zero shows that associate alert was triggered thereon day, and a bar shows that the alarm has been triggered quite n times in x days. The user will right click and show information for each dots and bars.<\/p>\n

i. Moving average over variable periods<\/h4>\n

You have computed the moving average for sales for all months by victimization the fast table calculation functions in Tableau, however, would currently prefer to extend it in order that you’ll be able to select what percentage periods you would like to average.<\/p>\n

\"Tableau<\/a><\/p>\n

The pale blue line shows the addition of sales for all months whereas the orange line shows the 15-period moving average of sales.<\/p>\n

The combination of a Parameter and a custom-built fast Table Calculation for moving average lets US average over variable periods.<\/p>\n

j. Distinction from the average by an amount<\/h4>\n

You may be additional inquisitive about seeing the distinction in quarterly sales from that year\u2019s average than absolutely the variety. Here we tend to show each the distinction between the year\u2019s average and therefore the absolute variety of orders.<\/p>\n

\"Table<\/a><\/p>\n

\n
\n
So, this was all on Table Calculation in Tableau. Hope you like our explanations.<\/span><\/div>\n

Conclusion<\/h3>\n<\/div>\n<\/div>\n

In this Tableau tutorial, we learned about the table calculation in Tableau, how to create Table Calculation in Tableau, a stepwise procedure to create them. Furthermore, if you have any query, feel free to ask in a comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"

This Tableau Table Calculations tutorial, we explained what is Tableau Table Calculations advanced functions and their uses. It also demonstrates how to create a table calculation in Tableau using the calculation editor. What is...<\/p>\n","protected":false},"author":5,"featured_media":11625,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[2691,5174,9458,11671,14135,14187,15469],"class_list":["post-11604","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-common-baseline","tag-grouping-by-a-calculation","tag-percent-of-total-sales-over-time","tag-running-total","tag-table-calculation-in-tableau","tag-tableau-calculation","tag-weighted-average"],"yoast_head":"\nTable Calculation in Tableau - Calculation Function - DataFlair<\/title>\n<meta name=\"description\" content=\"What is Table Calculation in Tableau - Types of Tablea calculation,Percent change from a reference date, Common baseline, Protective ranking, Running total\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Table Calculation in Tableau - Calculation Function - DataFlair\" \/>\n<meta property=\"og:description\" content=\"What is Table Calculation in Tableau - Types of Tablea calculation,Percent change from a reference date, Common baseline, Protective ranking, Running total\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-23T12:19:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-01T16:16:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Table-calculation-in-tableau-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Table Calculation in Tableau - Calculation Function - DataFlair","description":"What is Table Calculation in Tableau - Types of Tablea calculation,Percent change from a reference date, Common baseline, Protective ranking, Running total","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/","og_locale":"en_US","og_type":"article","og_title":"Table Calculation in Tableau - Calculation Function - DataFlair","og_description":"What is Table Calculation in Tableau - Types of Tablea calculation,Percent change from a reference date, Common baseline, Protective ranking, Running total","og_url":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-23T12:19:33+00:00","article_modified_time":"2025-03-01T16:16:20+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Table-calculation-in-tableau-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Table Calculation in Tableau – Calculation Function","datePublished":"2018-03-23T12:19:33+00:00","dateModified":"2025-03-01T16:16:20+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/"},"wordCount":991,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Table-calculation-in-tableau-01.jpg","keywords":["Common baseline","Grouping by a calculation","Percent-of-total sales over time","Running total","Table Calculation in Tableau","Tableau Calculation","Weighted average"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/","url":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/","name":"Table Calculation in Tableau - Calculation Function - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Table-calculation-in-tableau-01.jpg","datePublished":"2018-03-23T12:19:33+00:00","dateModified":"2025-03-01T16:16:20+00:00","description":"What is Table Calculation in Tableau - Types of Tablea calculation,Percent change from a reference date, Common baseline, Protective ranking, Running total","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Table-calculation-in-tableau-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Table-calculation-in-tableau-01.jpg","width":1200,"height":628,"caption":"Table Calculation in Tableau"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/table-calculation-in-tableau\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Tableau Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/tableau\/"},{"@type":"ListItem","position":3,"name":"Table Calculation in Tableau – Calculation Function"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11604","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=11604"}],"version-history":[{"count":8,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11604\/revisions"}],"predecessor-version":[{"id":144430,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11604\/revisions\/144430"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/11625"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=11604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=11604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=11604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}