Getting counts of last year,,,

[#1]

Hello all,,,

I'm unable to get the count value(invitation_id) of the last year's invitation.

Script:

Load `invitation_id`,

`date_created`;

SQL SELECT

`date_created`,

      `invitation_id`

      FROM invitation;

Expression:

count({$<date_created={$(=Year(date_created) - 1)}>}invitation_id)

Thanks in advance

[sunny_talwar · Accepted solution]

Try like this:

Load `invitation_id`,

`date_created`,

Year(date_created) as Year_Created;

SQL SELECT

`date_created`,

      `invitation_id`

      FROM invitation;

Expression:

count({$<Year_Created={$(=Max(Year_Created) - 1)}>}invitation_id)

[Anonymous]

try something like the example below, maybe you'll need to play with variable assignment in the set analysis.

LET vLastYear = year(today()) -1;

count({$<date_created={'$(vLastYear)'}>}invitation_id)

[#4]

Thank u sunny,,,,it worked well.