Expression dependent on Year part of TimeStamp?

[#1]

Hi,

So I have some items with dates and I want to make a graph that displays the  items depending on the year that they were published. So, for example I want to show all the items that were published in 2013. So I tried using:

count({<Year(CLOSE_DATE) = 2013>}ID)

But this doesn't work.

Any help?

[#2]

Hi Beth,

In set analysis, you can't use calculated dimension (like Year(CLOSE_DATE)). To show all the items that were published in 2013, try with this expression :

Count({$<CLOSE_DATE = {">=$(=MakeDate(2013,01,01))"}>} ID)

Hope it helps.

Regards,

Nicolas

[kaushiknsolanki · Accepted solution]

Hi,

     Better you create a field in your script.

     Something like below.

     Load *,Year(CLOSE_DATE) as Year from XYZ;

     Then you can use the below expression.

     Count({<Year = {"2013"}>}ID)

Regards,

Kaushik Solanki

[#4]

Thanks this worked