Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
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)
Thank u sunny,,,,it worked well.