Quick question on set analysis formula

kalmirall — Wed, 28 Oct 2015 19:22:29 GMT

I'm trying to add in a piece to my set analysis formula to add a condition of having an assignment submission date in addition to an attempt. The first formula is working fine:

Count(DISTINCT {$ <[assignmentsubmissions.attempt]={">=1"}>} [CanvasSchools.CanvasEnrollments.user_id])

But when I try to add in that second piece:

Count(DISTINCT {$ <[assignmentsubmissions.attempt]={">=1"}, len([assignmentsubmissions.submitted_at])={"<>0"}>} [CanvasSchools.CanvasEnrollments.user_id])

The formula wizard says I have an error in my set modifier expression. I'm new to set analysis so any tweaks/help appreciated- hoping there is a quick and easy answer!

Thanks!

Re: Quick question on set analysis formula

swuehl — Wed, 28 Oct 2015 19:28:53 GMT

You need to use field names, no expressions allowed, left of the equal sign in a set modifier.

Maybe try like this

Count(DISTINCT {$ <[assignmentsubmissions.attempt]={">=1"}, [assignmentsubmissions.submitted_at] ={"*"}>} [CanvasSchools.CanvasEnrollments.user_id])

topic Quick question on set analysis formula in App Development

Quick question on set analysis formula

Re: Quick question on set analysis formula