Practice - 5 Tasks
Answer the questions below
1fill in blank
easyComplete the code to create a bin of size 10 for the Sales field.
Tableau
INT([Sales] / [1]) * 10
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using the wrong bin size number.
Forgetting to multiply back after division.
✗ Incorrect
Dividing Sales by 10 groups the values into bins of size 10.
2fill in blank
mediumComplete the code to create bins of size 50 for the Profit field.
Tableau
INT([Profit] / [1]) * 50
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using a number smaller or larger than the bin size.
Not using INT to round down.
✗ Incorrect
Dividing Profit by 50 groups the values into bins of size 50.
3fill in blank
hardFix the error in the bin calculation for Quantity with bin size 5.
Tableau
INT([Quantity] [1] 5) * 5
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using multiplication instead of division.
Using addition or subtraction which does not group values.
✗ Incorrect
To create bins, divide Quantity by the bin size, then multiply back.
4fill in blank
hardFill both blanks to create bins of size 20 for Discount.
Tableau
INT([Discount] [1] [2]) * 20
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Multiplying before dividing.
Using wrong bin size number.
✗ Incorrect
Divide Discount by 20 to group, then multiply by 20 to get bin start.
5fill in blank
hardFill all three blanks to create bins of size 100 for Sales with rounding.
Tableau
ROUND(INT([Sales] [1] [2]) * [3], 0)
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using multiplication instead of division first.
Not multiplying back by bin size.
Not rounding the result.
✗ Incorrect
Divide Sales by 100, multiply by 100, then round to nearest integer for bins.