How to visualize chart last 12 month backwards (exclude current month)

[Anonymous]

Dear Team,

How to exclude 2018 Apr? I already try to minus 20 days from today's date, but it didn't works.

Please help. Thanks.

[rachel_delany]

Try something like this:

<[Modified Date]={">=$(=AddMonths(MonthStart(Today()),-11))"}, [Modified Date]={"<=$(=MonthStart(Today()))"}>}

Essentially it is adding another conditioning saying that the date should be less than the start day of the current month.

[Anonymous · Accepted solution]

Hi Rachel,

I get your points. i modify it to be like this. its working now. Thanks.

=Num(Count({$<Status={'Completed'}>*$<[PSR No]-={"''"}> *$<Temp={'Task_W'}>

*$<[Modified Date]={">=$(=AddMonths(MonthStart(Today()),-12))"}>

*$<[Modified Date]={"<$(=MonthStart(Today()))"}>

} ([PSR No])),'##.0')