So I have the report 2019-01-01 to 2019-12-31, Age basket: <1, 1-10, 11-21; and have to calculate doctor visits base on Age - end of each enrollment month.
Age = (2019-01-31, DOB)
Age = (2019-02-28, DOB)
...
How can I do this?
Thank you
You can use the _last_of_month() function on your enrollment month field and then compare it to the date of birth field using _years_between().