📋 Summary:

What it calculates: Calculates the growth ratio for club memberships by comparing signed up/cancelled flags and active/on-hold status across current and previous periods, focusing on new memberships and membership state changes WHERE membership is not excluded from reporting and is not a membership switch.

Variants:
• Growth Ratio CP: Current period membership growth calculation
• Growth Ratio PP: Previous period membership growth calculation
• Growth Ratio Δ: Absolute difference in membership growth between periods
• Growth Ratio Δ%: Percentage change in membership growth between periods

How to use it:
• Analyze wine club membership acquisition and retention trends
• Evaluate membership growth rate across different time periods
• Identify potential membership churn or expansion signals

Tip: The complex formula normalizes membership counts by considering signed up, cancelled, active, and on-hold flags to provide a nuanced view of membership dynamics beyond simple headcount.

This summary was generated by AI.

📊 Quick Stats:

🏷️ Type: Calculated metric
📁 Build Beyond Limits Group: μ Growth Ratio

Copy of Copy of Memberships Growth Ratio Δ%

🔢 Formula

((m₁  ÷  ((((m₂  ÷  m₃))))) - (m₄  ÷  (m₅  ÷  m₆)))  ÷  (m₇  ×  (m₈  ÷  m₉))
with:
m₁ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₂ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
m₃ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
m₄ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₅ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
m₆ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
m₇ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₈ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
m₉ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'

Output Format: #,##0

Formula Last Updated: 2025-11-14T07:02:16Z

Denominator Growth Ratio Δ%

🔢 Formula

(m₁  ×  (m₂  ÷  m₃))
with:
m₁ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₂ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
m₃ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'

Output Format: #,##0.00

Formula Last Updated: 2025-05-05T17:17:43Z

Memberships Growth Ratio CP

🔢 Formula

m₁  ÷  (m₂  ÷  m₃)
with:
m₁ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₂ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
m₃ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'

Output Format: ##0.0%

Formula Last Updated: 2025-05-05T14:55:37Z

Memberships Growth Ratio PP

🔢 Formula

m₁  ÷  (m₂  ÷  m₃)
with:
m₁ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₂ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
m₃ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'

Output Format: ##0.0%

Formula Last Updated: 2025-05-05T15:02:48Z

Memberships Growth Ratio Δ

🔢 Formula

(m₁  ÷  (m₂  ÷  m₃)) - (m₄  ÷  (m₅  ÷  m₆))
with:
m₁ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₂ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
m₃ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
m₄ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₅ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
m₆ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'

Output Format: ##0.0%

Formula Last Updated: 2025-05-05T15:02:10Z

Memberships Growth Ratio Δ%

🔢 Formula

((m₁  ÷  ((((m₂  ÷  m₃))))) - (m₄  ÷  (m₅  ÷  m₆)))  ÷  (m₇  ×  (m₈  ÷  m₉))
with:
m₁ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₂ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
m₃ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Current Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Current Period'
m₄ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₅ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
m₆ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
m₇ = Sum([Club Memberships Calendar].[Signed Up Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
        AND [Club Memberships Calendar].[Is Switch] = false
m₈ = Sum([Club Memberships Calendar].[Active Flag])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'
        AND [Club Memberships Calendar].[Is Excluded From Reporting] = false
m₉ = Distinct Count([Club Memberships Calendar].[Membership Date])
    WHERE
        [Club Memberships Calendar].[Membership Date] ≥ 'Start of Previous Period'
        AND [Club Memberships Calendar].[Membership Date] ≤ 'End of Previous Period'