Looking for a search to count number of transactions an employee has created and compare it year over year.

You probably want to use

Created By

(grouped) and the

TO_DATE()

function to extract the year (grouped) from the

Created Date

. And use count of internalid. Filter your results to

Mainline = T

as well.

That is the one i am struggling with....the date.. i want to show 2019 and 2020....can you elaborate on

TO_DATE()

function?

THANK YOU! I will take a look at this

If you want a look like one row per user, something like each column being a

CASE WHEN

should work for that, e.g.:

CASE WHEN TO_CHAR({datecreated}, 'YYYY') = '2019' THEN 1 ELSE 0 END

PERFECT, THANK YOU!