Tableau - LOD Sales Tracker

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.


Dash-Intel is a Power BI and Tableau resource site for data visualization and building BI dashboards.

Data Analyst & Consultant

Copyright 2015-2023 Dash-Intel.com Terms