Set Analysis - >= of a String Value

[SNarendran]

Hi,

I have a yearmonth field in my script.

It reads like 2017-01.

I want my set analysis expression to give me a count of values from another field when the yearmonth field is >= '2017-01'.

What will my set analysis expression be?

COUNT({<YearMonth_Created ={">= Date#(2017-01)"} >} NL_MLS) doesn't work

[Taoufiq_Zarra]

Hi,

I suggest you create a field from the [YearMonth_Created] field in the load script:

Date(Date#(YearMonth_Created,'YYYYY-MM')) as New_YearMonth_Created,

then uses this field in set analysis

=COUNT({<New_YearMonth_Created ={">= Date(Date#('2017-01','YYYY-MM'))"} >} NL_MLS) 

Cheers,

[SNarendran]

Thank you 

[manoranjan_d]

Pls accept the solution and close the post as solved 

[SNarendran]

Doesn't work unfortunately

[Taoufiq_Zarra]

can you share a sample of your data?

[SNarendran]

Attached. I want to be able to show:

A count of MLS and newMLS From the beginning of my Solddate.

Thanks

Shashank

[SNarendran]

Dimension has to be CreateDate

[Taoufiq_Zarra]

if I have understood correctly , both formulas are attached
I don't know if that's the output you want.

[SNarendran]

Thanks. 

If you can create a straight table for me with the Created Date as the dimension and the count of NewMLS  as an expression?