The Task is to create a Sales Per Day Tracker with high, medium and low sales days
Step 1: Create a new LOD calculated field in Tableau called "Sales Per Day" and type
{FIXED [Order Date]: SUM([Sales])}
Step 2: Create a new LOD calculated field in Tableau called "Sales Per Day" and type
IF [Sales Per Day] > 3000 THEN 'high'
ELSEIF [Sales Per Day] > 2000 THEN 'medium'
ELSE 'low'
END
Step 3: Add "OrderDate" to the both the row and column shelf and "Sales Tracker" to color shelf and row shelf
Step 4: For "OrderDate" in the row shelf, right click and select measure->Count (Distinct)
Step 5: Expand YEAR(OrderDate) on the row shelf to show quarters
Step 6: On the right hand side, reorder the legend by clicking and dragging to show high, medium and low
Step 7: Set the marks type to Bar or Area chart.