Bash, the Crucial Exams Chat Bot
AI Bot
Calculations and Aggregations Flashcards
Tableau Desktop Foundations Flashcards
| Front | Back |
| How do you calculate a percentage of total in Tableau | Using the Percent of Total quick table calculation or by dividing a field's value by the sum of the field and formatting it as a percentage. |
| How does Tableau handle NULL values in calculations | Null values are ignored in aggregations but can be handled using functions like IFNULL or ZN. |
| How is a calculated field created in Tableau | By clicking on Analysis > Create Calculated Field or using the data pane's dropdown menu. |
| What does a "fixed LOD" (Level of Detail) expression aggregate | A specific dimension or set of dimensions regardless of other filters or aggregations. |
| What does the AVG function do | Calculates the average value of a numeric field. |
| What does the CONCAT function do in Tableau | Combines two or more strings into one continuous string. |
| What does the IF function do | Performs conditional tests to return different outcomes based on the test's result. |
| What does the LEFT function do | Extracts a specified number of characters from the start of a string. |
| What does the LEN function do in Tableau | Returns the length of a string (number of characters). |
| What does the SUM function do | Calculates the total sum of a numeric field. |
| What does the TRIM function do | Removes leading and trailing spaces from a string. |
| What is a calculated field | A field in Tableau created by combining or transforming data using expressions or formulas. |
| What is an aggregation | The process of summarizing data using methods like SUM, AVG, MIN, MAX, COUNT, etc. |
| What is the basic syntax for the addition operation in Tableau | A + B |
| What is the difference between MIN and MAX functions | MIN returns the smallest value, while MAX returns the largest value of a numeric field. |
| What is the purpose of arithmetic functions in Tableau | To perform mathematical operations like addition, subtraction, multiplication, and division. |
| What is the purpose of logical functions in Tableau | To evaluate conditions and return true/false or perform conditional operations. |
| What is the purpose of string functions in Tableau | To manipulate or transform text data fields. |
| What is the syntax for division in Tableau | A / B |
| What type of data does the COUNT function aggregate | Counts the number of rows or records in a dataset. |
This deck introduces basic calculations, calculated fields, aggregations, and different types of functions like logical, arithmetic, and string functions in Tableau.