Aggr PODs All Time

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

🔢 Formula

m₁  ÷  m₂
with:
m₁ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

Output Format: #,##0.00

Formula Last Updated: 2025-08-10T18:40:25Z

Aggr PODs MTD

Month-to-Date is partially dependent on the date picker. The end date determines the current month, while the start date is automatically set to the first day of that month. Measures labeled with 'MTD' ignore the start date in the picker but are affected by the end date and applied filters.

🔢 Formula

m₁  ÷  m₂
with:
m₁ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

Output Format: #,##0.00

Formula Last Updated: 2025-08-10T18:40:41Z

Aggr PODs MTD LY

This measure compares the same month as the Current MTD but for the previous year. The end date determines the month last year, with the start date set to the first day of that month. Measures labeled with 'MTD LY' are influenced by the end date and any applied filters.

🔢 Formula

m₁  ÷  m₂
with:
m₁ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

Output Format: #,##0.00

Formula Last Updated: 2025-08-10T18:40:52Z

Aggr PODs MTD Δ

This is the absolute difference between the Current MTD and the Previous MTD periods. The end date in the picker determines the current month, with the start date defaulting to the month's first day. Measures labeled with 'MTD Δ' are governed by the end date and any applied filters.

🔢 Formula

(m₁  ÷  m₂) - (m₃  ÷  m₄)
with:
m₁ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₃ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₄ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

Output Format: #,##0.00

Formula Last Updated: 2025-08-10T18:41:01Z

Aggr PODs MTD Δ%

This represents the percentage difference between the Current MTD and the Previous MTD periods. Measures labeled with 'MTD Δ%' follow the same rules as 'MTD Δ,' depending on the end date and any applied filters.

🔢 Formula

(m₁  ÷  m₂)  ÷  (m₃  ÷  m₄) - 1
with:
m₁ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₃ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₄ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Month in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

Output Format: ##0.0%;-##0.0%

Formula Last Updated: 2025-08-10T18:33:03Z

Aggr PODs YDAY

'Yesterday' corresponds to the end date selected in the date picker. Measures labeled with 'YDAY' are unaffected by the start date in the picker and are subject to applied filters, including time-based ones (e.g., Completed Year-Month).

🔢 Formula

m₁  ÷  m₂
with:
m₁ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Invoice Date] = 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] = 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

Output Format: #,##0.00

Formula Last Updated: 2025-08-10T18:41:16Z

Aggr PODs YTD LY

This measure compares the same year-to-date range as the Current YTD but for the previous year. The end date determines the year last year, with the start date set to the year's first day. Measures labeled with 'YTD LY' are subject to the end date and applied filters.

🔢 Formula

m₁  ÷  m₂
with:
m₁ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

Output Format: #,##0.00

Formula Last Updated: 2025-08-10T18:41:32Z

Aggr PODs YTD Δ

This is the absolute difference between the Current YTD and Previous YTD periods. The end date determines the current year, while the start date defaults to the year's first day. Measures labeled with 'YTD Δ' adhere to the end date and applied filters.

🔢 Formula

(m₁  ÷  m₂) - (m₃  ÷  m₄)
with:
m₁ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₃ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₄ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'

Output Format: #,##0.00

Formula Last Updated: 2025-08-10T18:41:43Z

Aggr PODs YTD Δ%

This represents the percentage difference between the Current YTD and Previous YTD periods. Measures labeled with 'YTD Δ%' follow the same rules as 'YTD Δ,' depending on the end date and applied filters.

🔢 Formula

(m₁  ÷  m₂)  ÷  (m₃  ÷  m₄) - 1
with:
m₁ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₃ = Distinct Count([Items].[Brand Description])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₄ = Distinct Count([Depletions].[Outlet Eid])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Year in Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Is Sample Order] = false
        AND [Outlets].[Outlet Premise Type] ≠ 'DTC'