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.





Services
  • SEO
  • Online Advertising
  • Online Ordering For Restaurants
  • Data Analytics

  • External Resources 4 Developers
  • CSS Tricks
  • MDN

  • Dash-Intel.com is a Power BI and Tableau resource site around data visualizations and building business dashboards.

    Data Analytics consultants in Edmonton, Alberta specializing in Tableau and marketing analytics

    Copyright 2020 Dash-Intel.com Terms / All rights reserved.