Monthly home visit count

Hi ,

We have three different forms showing individual home visit I would like to
see the summary of the total home visit in a month as per form. How is it
possible?

Link:-

https://www.commcarehq.org/a/sc-baseline/apps/view/0cfbaec12e57a7d1f1269773026b35bd/modules-2/forms-0/source/

Regards
Latika
SNEHA

Hi Latika,

This would depend on whether you are tracking the number of home visits
received by an individual or the number of home visits performed by the
user.

If you are tracking the visits per individual, you could increment a
counter on the case by loading the value, adding one to it, and saving it
back to the individual’s case.

If you re tracking visits performed by the user, you could instead track
that counter on the ‘User Case’ for that user
https://confluence.dimagi.com/display/commcarepublic/User+Case .

Since you want the number of visits in a month, you’ll need to keep track
of two values, the “number of visits” and the “tracked month”. When you
load the number of visits into the form, you’d need to check whether the
month now (say, April) was the same as the ‘tracked month’ stored in the
case currently (say, March), and if not, you’d reset the "number of visits"
counter to 1 instead of “current_number_of_visits + 1”, and then set the
tracked month to be the current month.

A helpful expression for what you are trying to do would be

int(format-date(now(), ‘%m’))

which you can set as the Calculate condition in a form to get the number of
the current month in the year (April -> 4, May -> 5, etc).

-Clayton

··· On Fri, Apr 7, 2017 at 7:35 AM, Latika Sb wrote:

Hi ,

We have three different forms showing individual home visit I would like
to see the summary of the total home visit in a month as per form. How is
it possible?

Link:-

https://www.commcarehq.org/a/sc-baseline/apps/view/
0cfbaec12e57a7d1f1269773026b35bd/modules-2/forms-0/source/

Regards
Latika
SNEHA


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Latika,

Do you have 3 separate forms that each count as a home visit? If you want
to just see the numbers quickly you could use the Submissions by Form
report on the Reports tab on CommCareHQ. You would set the filter to the
prior month, export the report, and then just add together the totals for
the columns that correspond to the forms that count as home visits.

I hope this helps!

Jeremy

··· On Fri, Apr 7, 2017 at 7:35 AM, Latika Sb wrote:

Hi ,

We have three different forms showing individual home visit I would like
to see the summary of the total home visit in a month as per form. How is
it possible?

Link:-

https://www.commcarehq.org/a/sc-baseline/apps/view/
0cfbaec12e57a7d1f1269773026b35bd/modules-2/forms-0/source/

Regards
Latika
SNEHA


Jeremy Wacksman
Dimagi http://www.dimagi.com, Inc.