Number of the last week of the month

[mvtriff]

Hi all,

I'm trying to apply a Background Color Expression to highlight the number of the last week in the month.

Could someone please help me with this?

Thank you for your time.

 

Regards,

M.

[edwin]

to simplify your chart, you can flag the last week of the month in your script.

one way would be get the max(Week) or maxstring(Week) group by month  this will give you the last week of each month.  you an then join it with your calendar using month