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