Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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?
With this you will have a "Year to Date"
Count ({<YEAR={$(=Year(Today()))},DATE={"<=$(=(Today())"}>}DATA)