JStrittmatter
Technical User
I need to calcuate an unduplicated count of new people every month throughout the fiscal year which is July - June. Can anyone please help me I would greatly appreciate it.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Select consumer_uuid from SERVICE_DELIVERY where
SERVICE_MONTH = <currentmonth> and SERVICE_YEAR=<currentyear>
MINUS
Select consumer_uuid from SERVICE_DELIVERY where
(SERVICE_MONTH <> <currentmonth> and
SERVICE_YEAR<><currentyear>);