📋 Summary:

What it calculates: Average net sales per day with orders, specifically for Tasting Room channel, calculated by summing (Quantity × Sold Price) and dividing by count of days with completed orders, WHERE Order Status = 'Completed' AND Payment Status IN ('Paid', 'Refunded', 'External') AND Channel Type = 'Tasting Room', excluding $0 orders.

Variants: CP shows current period average, PP shows prior period average, Δ shows absolute difference between periods, Δ% shows percentage change between periods.

How to use it:
• Track daily Tasting Room sales performance
• Compare revenue consistency across different time periods
• Assess Tasting Room channel productivity

Tip: Ensure date pickers cover equivalent periods for accurate comparative analysis, and verify that zero-dollar orders are consistently excluded.

This summary was generated by AI.

📊 Quick Stats:

🏷️ Type: Calculated metric
📁 Build Beyond Limits Group: Σ Net Sales TR/Days with Orders (Excl $0)

Net Sales TR/Days with Orders (Excl $0) CP

🔢 Formula

m₁  ÷  m₂
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Order Items].[Order Completed Date] ≥ 'Start of Current Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
        AND [Order Items].[Channel Type] = 'Tasting Room'
m₂ = Distinct Count([Orders].[Order Completed Date])
    WHERE
        [Orders].[Order Completed Date] ≥ 'Start of Current Period'
        AND [Orders].[Order Completed Date] ≤ 'End of Current Period'
        AND [Orders].[Order Status] = 'Completed'
        AND [Orders].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Orders].[Is 0 Dollar Order] = false
        AND [Orders].[Channel Type] = 'Tasting Room'

Output Format: $#,###.00

Formula Last Updated: 2025-04-05T18:15:50Z

Net Sales TR/Days with Orders (Excl $0) PP

🔢 Formula

m₁  ÷  m₂
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Order Items].[Order Completed Date] ≥ 'Start of Previous Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Previous Period'
        AND [Orders].[Channel Type] = 'Tasting Room'
m₂ = Distinct Count([Orders].[Order Completed Date])
    WHERE
        [Orders].[Order Completed Date] ≥ 'Start of Previous Period'
        AND [Orders].[Order Completed Date] ≤ 'End of Previous Period'
        AND [Orders].[Order Status] = 'Completed'
        AND [Orders].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Orders].[Is 0 Dollar Order] = false
        AND [Orders].[Channel Type] = 'Tasting Room'

Output Format: $#,###.00

Formula Last Updated: 2025-04-05T18:17:09Z

Net Sales TR/Days with Orders (Excl $0) Δ

🔢 Formula

(m₁  ÷  m₂) - (m₃  ÷  m₄)
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Order Items].[Order Completed Date] ≥ 'Start of Current Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
        AND [Orders].[Channel] = 'Tasting Room'
m₂ = Distinct Count([Orders].[Order Completed Date])
    WHERE
        [Orders].[Order Completed Date] ≥ 'Start of Current Period'
        AND [Orders].[Order Completed Date] ≤ 'End of Current Period'
        AND [Orders].[Order Status] = 'Completed'
        AND [Orders].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Orders].[Is 0 Dollar Order] = false
        AND [Orders].[Channel Type] = 'Tasting Room'
m₃ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Order Items].[Order Completed Date] ≥ 'Start of Previous Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Previous Period'
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Orders].[Channel Type] = 'Tasting Room'
m₄ = Distinct Count([Orders].[Order Completed Date])
    WHERE
        [Orders].[Order Completed Date] ≥ 'Start of Previous Period'
        AND [Orders].[Order Completed Date] ≤ 'End of Previous Period'
        AND [Orders].[Order Status] = 'Completed'
        AND [Orders].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Orders].[Is 0 Dollar Order] = false
        AND [Orders].[Channel Type] = 'Tasting Room'

Output Format: $#,###.00

Formula Last Updated: 2025-04-05T18:18:31Z

Net Sales TR/Days with Orders (Excl $0) Δ%

🔢 Formula

(m₁  ÷  m₂)  ÷  (m₃  ÷  m₄) - 1
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Order Items].[Order Completed Date] ≥ 'Start of Current Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
        AND [Orders].[Channel] = 'Tasting Room'
m₂ = Distinct Count([Orders].[Order Completed Date])
    WHERE
        [Orders].[Order Completed Date] ≥ 'Start of Current Period'
        AND [Orders].[Order Completed Date] ≤ 'End of Current Period'
        AND [Orders].[Order Status] = 'Completed'
        AND [Orders].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Orders].[Is 0 Dollar Order] = false
        AND [Orders].[Channel Type] = 'Tasting Room'
m₃ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Order Items].[Order Completed Date] ≥ 'Start of Previous Period'
        AND [Order Items].[Order Completed Date] ≤ 'End of Previous Period'
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Orders].[Channel Type] = 'Tasting Room'
m₄ = Distinct Count([Orders].[Order Completed Date])
    WHERE
        [Orders].[Order Completed Date] ≥ 'Start of Previous Period'
        AND [Orders].[Order Completed Date] ≤ 'End of Previous Period'
        AND [Orders].[Order Status] = 'Completed'
        AND [Orders].[Payment Status] IN ('Paid', 'Refunded', 'External')
        AND [Orders].[Is 0 Dollar Order] = false
        AND [Orders].[Channel Type] = 'Tasting Room'