📋 Summary:
What it calculates: Calculates the ratio of total net sales (Quantity × Sold Price) to Average Order Value (AOV), excluding $0 orders, for completed orders with 'Paid', 'Refunded', or 'External' payment statuses within the selected time period.
How to use it:
• Assess revenue efficiency by understanding how net sales relate to average order size
• Identify trends in customer purchasing behavior across different time periods
Related measures: Items (Excl $0), Refunds (Excl $0)
Tip: Ensure date picker is set to desired analysis period; the measure automatically excludes zero-dollar transactions for a more accurate representation of meaningful sales activity.
This summary was generated by AI.
📊 Quick Stats:
🏷️ Type: Calculated metric
📁 Build Beyond Limits Group: Σ Net Sales to AOV (Excl $0) Ratio
Net Sales to AOV (Excl $0) Ratio CP
🔢 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 [Orders].[Completed Date] ≥ 'Start of Current Period'
AND [Orders].[Completed Date] ≤ 'End of Current Period'
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')
AND [Orders].[Completed Date] ≥ 'Start of Current Period'
AND [Orders].[Completed Date] ≤ 'End of Current Period'
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')
AND [Orders].[Completed Date] ≥ 'Start of Current Period'
AND [Orders].[Completed Date] ≤ 'End of Current Period'
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')
AND [Orders].[Completed Date] ≥ 'Start of Current Period'
AND [Orders].[Completed Date] ≤ 'End of Current Period'
Output Format: $#,###.00
Formula Last Updated: 2025-05-02T14:02:07Z
ℹ️ Additional Details
Key:
[calculation].[Net Sales to AOV (Excl $0) Ratio CP]ID:
4cd4c1cc-d09e-4780-b71d-3f6223469ecc
🏷️ Tags
Completed Date
Is 0 Dollar Order
Net Sales
Net Sales to AOV (Excl $0) Ratio CP
Order Eid
Order Status
Payment Status