Skip to main content
Level 1
September 22, 2026
Question

CJA Data Mismatch: Month of Year Dimension vs. Rolling Date Rows

  • September 22, 2026
  • 0 replies
  • 8 views

Hi,

I am seeing a data discrepancy in CJA when building a 12-month YoY chart inside a panel locked to "This Month" (September 2026).

Identical months (e.g., July, August, Sep) show completely different numbers for the People metric depending on the table setup:

Setup A: Generic Month of Year dimension in rows + custom Jan 1, 2026 - Dec 31, 2026 column override. (shows 9.9K people for Aug)

Setup B: Rolling date ranges in rows (This Month, 1 Month Ago, 2 Months Ago) + custom Jan 1, 2026 - Dec 31, 2026 column override. (Shows 6.8K people for Aug)

Why does the time-parting dimension (Setup A) data mismatch with that of the relative date components (Setup B)?