📋 Summary:

What it calculates: Calculates the ratio of total net sales dollars (Quantity × Sold Price) to Average Order Value (AOV), excluding $0 orders, WHERE Order Status = 'Completed' AND Payment Status IN ('Paid', 'Refunded', 'External')

Variants: Both measures are "All Time" variants, showing cumulative net sales to AOV ratio across the entire historical dataset, with strict order completion and payment filters

How to use it:
• Understand the relationship between total sales volume and average order size
• Track long-term revenue efficiency and customer purchasing patterns

Tip: The exclusion of $0 orders ensures that only meaningful transactions are included in the calculation, providing a more accurate representation of true sales performance

This summary was generated by AI.

📊 Quick Stats:

🏷️ Type: Calculated metric
📁 Build Beyond Limits Group: Σ Net Sales to AOV (Excl $0) Ratio Presets

Net Sales to AOV (Excl $0) Ratio All Time

This measure disregards the date picker entirely, relying only on applied filters, including time-based filters.

🔢 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')
m₂ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Orders].[Is 0 Dollar Order] = false
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
m₃ = Distinct Count([Order Items].[Order Eid])
    WHERE
        [Orders].[Is 0 Dollar Order] = false
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
m₄ = Distinct Count([Order Items].[Order Eid])
    WHERE
        [Orders].[Is 0 Dollar Order] = false
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')

Output Format: $#,###.00

Formula Last Updated: 2025-05-02T13:53:21Z

Total AOV (Excl $0) Ratio All Time

This measure disregards the date picker entirely, relying only on applied filters, including time-based filters.

🔢 Formula

(m₁  ÷  (m₂ - m₃))
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
    WHERE
        [Orders].[Is 0 Dollar Order] = false
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
m₂ = Distinct Count([Order Items].[Order Eid])
    WHERE
        [Orders].[Is 0 Dollar Order] = false
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
m₃ = Distinct Count([Order Items].[Order Eid])
    WHERE
        [Orders].[Is 0 Dollar Order] = false
        AND [Order Items].[Order Status] = 'Completed'
        AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')