Count Expression in Chart

[Anonymous]

I need help creating a COUNT expression with the attached data set.

Dimension: StartDate_YYYYMM

Expression:

AssignDate IS NOT NULL

Status = Open OR Status  = Closed when Enddate_YYYYMM = StartDate_YYYYMM

201608 = 50,213

201607 = 52,543

201606 = 45,026

[sunny_talwar]

I see this

Attaching the filtered Excel file for review. Can you show me how you get 1078

[Anonymous]

See attached, sorry for the confusion. I just removed the filter on StartDate_YYYMM. It doesn't matter when the customer started, just when they ended.

[sunny_talwar]

I think what you are looking to do will require a Canonical calendar here:

Canonical Date

[Anonymous]

Okay, I reviewed the article. Clearly I have a lot more learning but can you tell me why I would need a Canonical calendar to create the counts I'm looking for?

[sunny_talwar]

Because you want to count StartDate_YYYYMM values matching in EndDate_YYYYMM even when they are out of the StartDate_YYYYMM. For example

StartDate_YYYYMM     EndDate_YYYYMM

201607                         201608

201607                         201607

201608                         201608

Now what you are asking is to do something like this

StartDate_YYYYMM      Expression

201608                          2

Where as I don't know a way to do this, all we can get is

StartDate_YYYYMM      Expression

201608                          1