📋 Summary:

What it calculates: Total net sales dollars (Quantity × Sold Price) divided by the number of days with completed orders, excluding $0 orders, WHERE Order Status = 'Completed' AND Payment Status IN ('Paid', 'Refunded', 'External') within the selected time period.

Variants:
• CP: Current period calculation of net sales per order day
• PP: Prior period calculation of net sales per order day
• Δ: Absolute dollar difference between current and prior period
• Δ%: Percentage change in net sales per order day between periods

How to use it:
• Assess daily sales productivity for direct-to-consumer channels
• Compare revenue efficiency across different time periods
• Identify trends in order frequency and sales volume

Tip: Ensure date pickers are set to comparable periods (e.g., same month in different years) for accurate trending analysis. The measure automatically excludes zero-dollar orders to provide a more meaningful revenue per active day metric.

This summary was generated by AI.

📊 Quick Stats:

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

Net Sales /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'
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

Output Format: $#,###.00

Formula Last Updated: 2025-03-31T16:40:38Z

Net Sales /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'
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

Output Format: $#,###.00

Formula Last Updated: 2025-03-31T16:42:02Z

Net Sales /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'
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
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')
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

Output Format: $#,###.00

Formula Last Updated: 2025-03-31T17:00:23Z

Net Sales /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'
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
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')
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