Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Expression
Count({$<DateType={completion},final_test_status={"passed"},
YOY_Canon_Year = {"$(=year(max(CanonicalDate))-1)"}>}invitation_id)
For this i am adding to filter it by Canonical_Month={'Month_Last_Canon_Year'} .
Canonical_Month Month_Last_Canon_Year
Jan May
Feb June
MAr July
Apr Aug
MAy
June
July
Aug
Sep
Oct
Nov
Dec
So my expression becomes
Count({$<DateType={completion},final_test_status={"passed"},
YOY_Canon_Year = {"$(=year(max(CanonicalDate))-1)"},Canonical_Month={'Month_Last_Canon_Year'}>}invitation_id)
But this Canonical_Month={'Month_Last_Canon_Year'} is not getting applied. Count gives Zero.
Please help me on this.
Hi,
Check this