Reporting Question- Form Submissions week by week

Question

Hey all-

So I'm looking to build out a report for form submissions week by week and I'm running into some issues. I'm currently playing around with the "People Performance" reports and I'm like 90% of the way there, but the main problem is the "Group By" setting is limited. Meaning the only one I can really use to get a nice week by week grouping is "Created At". However, that skews the data because it groups people by when they where created....not by when they filled out the form.

I've tried customizing a "Program Performance" report but it doesn't allow me to filter programs by a time period OR group them by Channel without getting a view of ALL the programs.

Has anyone run into this in the past or have any solutions for a clean form submission report grouped by when the form was submitted rather than when the person was created?

Michael_Florin-2 · Answer

Yes, the "group by" function is limited to database fields. So you can't group by date of form submission.

Have you looked into Custom Columns? They might give you what you need. Create a couple of Smart Lists - in "Database" preferably - and have filters like "Has submitted form in past week" and "Has submitted form if week before that" and so on, and add these Smart Lists as Custom Columns to your Person Performance Report. For grouping select something that might actually add value like "Language" or so. (Unfortunately, you cannot not group.)

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded