Chart - Month/Year to date

[#1]

Hi,

How do I make my chart only show data up until todays date for previouse years?

I have tried doing it as an Expresstion like this:

Count ({<YEAR={$(vPreviousYear-1)},MONTH={'<=$(vMonth)'},DATE={'<=$(vToday)'}>}DATA)

But the result it the date is set as max in very month. So today it will only show up until todays date in all the present month also.

But I what the full data shown in the past months, and only month-to-date i present month.

[jmvilaplanap]

I going to try to explain it without variables

Try with this, this must to work

Count ({<YEAR={$(=Year(Today()))},MONTH={'$(=Month(Today()))'},DAY={"<=$(=Day(Today()))"}>}DATA)

[#3]

This are getting me the result of the 1th until today in every month. How do I get the full month in all the previouse months?

[jmvilaplanap]

With this you will have a "Year to Date"

Count ({<YEAR={$(=Year(Today()))},DATE={"<=$(=(Today())"}>}DATA)