You have a sales dataset with fields Sales Amount and Discount Rate (as a decimal). Which Tableau calculated field formula correctly calculates the total sales after applying the discount?
Remember that a discount reduces the sales amount by a percentage.
The correct formula multiplies the sales amount by (1 minus the discount rate) to reduce the sales by the discount percentage.
You want to show the profit margin percentage for different product categories. Which visualization type in Tableau best communicates this percentage clearly?
Think about which chart type makes comparing percentages across categories easiest.
A bar chart with profit margin percentage on the axis allows easy comparison of margin percentages across categories.
You have total sales and number of customers per region. Which Tableau calculated field formula correctly computes average sales per customer?
Average means total divided by count.
Average sales per customer is total sales divided by number of customers.
Your sales data does not include tax. You want to show sales including a 7% tax in your dashboard. Which calculated field formula correctly adds tax to sales?
Adding 7% tax means increasing sales by 7%.
Multiplying sales by 1.07 increases sales by 7%, correctly adding tax.
Consider this Tableau calculated field formula intended to calculate profit ratio:[Profit] / [Sales Amount]
However, the dashboard shows Null values for some rows. What is the most likely cause?
[Profit] / [Sales Amount]
Think about what happens when you divide by zero in Tableau.
Dividing by zero in Tableau results in Null values, which explains the Nulls in the dashboard.