Skip to main content

Σ % of Orders Basket Varietals (Excl $0)

Updated this week

% of Orders Basket Varietals (Excl $0) CP

Formula

m₁ / m₂
with:
m₁ = Distinct Count([Order Items].[Order Eid])
WHERE
[Order Items].[Order Completed Date] ≥ 'Start of Current Period'
AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
AND [Order Items].[Is 0 Dollar Order] = false
m₂ = Distinct Count([Order Items].[Order Eid])
WHERE
[Order Items].[Order Completed Date] ≥ 'Start of Current Period'
AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
AND [Order Items].[Is 0 Dollar Order] = false


Additional Details

  • Output Format: ##0.0%

  • Created: 2024-09-12T15:21:11Z

  • Last Updated: 2024-10-10T14:37:15Z

  • Key: [calculation].[% of Orders Basket Varietals (Excl $0) CP]


Tags

  • % of Orders Basket Varietals (Excl $0) CP

  • Completed Date

  • Is 0 Dollar Order

  • Order Eid

  • Varietal

Did this answer your question?