start and end dates

[#1]

Good morning

Posted a question about a rolling 12 month calculation which I've managed to get right now, using expression below. But now I'm unable to make any further selections i.e. select regions etc.

I'm wondering if I should use a variable to select a start and end date - are there any other options?

This is the expression I have for the rolling year.

count({1<DateRaised={">=$(=addmonths(monthend(max(DateRaised))+1,-12)) <=$(=max(DateRaised))"}StatusFlagID

)

[#2 · Accepted solution]

Try

count({$<DateRaised={">=$(=addmonths(monthend(max(DateRaised))+1,-12)) <=$(=max(DateRaised))"}StatusFlagID

)

The 1 or $ sign means that you base you calculation on the complete set of data (1) or the current selection ($). By using current selections ($), you can still change the region selections and such.

[#3]

Thanks that seems to be working find now, although I have noticed that when I select a region the date range changes which I assume has something to do with the $(=max(DateRaised)) part.