Rolling 13 Months show only values of last week

[migueldelval]

Hi all,

I have contacts for each week. And I show this information in a mini graph, but only last 5 weeks. I use this expression:

=Sum({<Week_INF={">=$(=WeekStart(Max(Week_INF)-28))<=$(=Max(Week_INF))"}}>}CONTACS)

But Now I need to make a other graph what Dimension it´s Month, and I need to show the Contacs information for the last 13 months.

But for each month I only might to show the value of the last week.

Its a little bit strange but it´s my requirement.

Can somebody help me?

Regards

Miguel del Valle

[sunny_talwar]

May be create a flag in the script for the last 7 days of every month in the script and then use that to calculate what you might be looking for