create count over 12 months from the date

[#1]

Hi The community,

I don't understand mistake.

I want to create a graphiq with this expression :

= COUNT({$<Date={">=$(=MonthStart(AddMonths(Max(MoisDateCreationOT),-12)))"}*{"<$(=MonthEnd(Max(MoisDateCreationOT)))"}>}ID_OT)))

but screen displays anything

I want to display ID_OT by month and more precisely over 12 months from the date

How can I do?

Thanks a lot

[jagan]

Hi,

Try like this

= COUNT({$<Date={">=$(=MonthStart(Max(MoisDateCreationOT),-12))<$(=MonthEnd(Max(MoisDateCreationOT)))"}>}ID_OT)

Hope this helps you.

Regards,

Jagan.

[Gysbert_Wassenaar]

1. Try

COUNT({$<Date={">=$(=MonthStart(AddMonths(Max(MoisDateCreationOT),-12)))<$(=MonthEnd(Max(MoisDateCreationOT)))"}>}ID_OT)))

2. If you want to use month as dimension and show the count as a rolling count over 12 month you can't use set analysis. You can try using an AsOf table. See this document for more information: Calculating rolling n-period totals, averages or other aggregations