Chart Expression

[Anonymous]

I need to count when status = open, AssignDate  Is not null (or for this example the word Null) AND when then End date column ends in that month. See attached for example as I would like to keep the same format in my example.  but below gives a better idea of what I'm looking for.

July = 52,597

June = 54,873

Customer ABC has a Start Date of 1/1/2016  and EndDate of 6/1/2016 (Could be anytime in June) The counts would look something like this...

            0                    1                      1                    1                    1                        1                    1                       0         

Month 201607        201606           201605         201604           201603           201602             201601           201512     Display only six values but the counts continue

[Anonymous]

If this cannot be figured out. Is it possible to do the below?

Customer ABC has a Start Date of 1/1/2016  and EndDate of 6/1/2016 (Could be anytime in June) The counts would look something like this...

            0                    1                      1                    1                    1                        1                    1                       0         

Month 201607        201606           201605         201604           201603           201602             201601           201512     Display only six values but the counts continue

Something like below (I know this is not correct)

=If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(RangeSum(Below(Count({<Status = {'Open'} , OR  ENDDATE_YYYYMM = STARTDATE_YYYYMM  >}ID), 0, NoOfRows() - RowNo() + 1))) + Count(ID))
//counts all open and closed of the current month when EndateDate = StartDate

[chrisg]

HI John,

just to be surewhere is your customer in the data model?

Thx

Christoph

[Anonymous]

ID would be my unqiue customer.

My dimension would be StartDate_YYYYMM

Does that answer your question?

[Anonymous]

If I need to make changed to my data model, I'm fine with doing so. I  need to be able to create counts as I mentioned above.