Count Ids for Max Month

[brf10043]

Team,

I have a simple problem and can't seem to work it out.  I have a table that has [CW ID] and a month value.  The data is updated once at the beginning of the month with the previous month's data which means that from March 1 until April 1 the table will only contain data up to and including Feb and on April 1 the March data comes in.

I am trying to do a count of [CW ID] but only for the mac month in the data and can't seem to get the code working.

Suggestions?

Examples? 

[sunny_talwar]

May be this:

Count({<Month = {"$(=Max(Month))"}>}[CW ID])

[brf10043 · Accepted solution]

Thanks Sunny,

When I try to use this code as my expression the chart displays a "No data to display" error.

Count({<CW_Month = {"$(=Max(CW_Month))"}>}[CW ID])

[sunny_talwar]

How is CW_Month created in the script? What do you see when you use Max(CW_Month) in a KPI Object?

[brf10043]

Thanks Sunny!  I worked it out.  I wasn't using the correct date column and I need to count Distinct records!

Count({<CW_Date = {"$(=Max(CW_Date))"}>}Distinct [CW ID])

[sunny_talwar]

Great