- «statCountIf(self.sgqa,"") = 2 (Hoping to see: number of empty answers, but this answer is the total answers to this question: Only completed responses are counted.)» no way currently to count seen but not answered response. Must report as a feature (Reason : "" == null == false)
- «statCountIf(self.sgqa,NA) = (Hoping to see: number of empty answers) :» No way, and surely not like this
- «statCount(Q00.sgqa, submitted=true) = (Hoping to see: number of answers to Q00 from completed surveys) » [, submitted=true] mean an optionnal parameter, default to true. NEVER use submitted=true because you set variable submitted to true (for expression manager), and true is a var name too : error for expression manager :return "" (empty string) Then statCount(Q00.sgqa, submitted=true) == statCount(Q00.sgqa)
- «statCount(Q00.sgqa, submitted==true)» error for expression manager :return "" (empty string)
- statCount(Q00.sgqa, submitted=false) error for expression manager :return "" (empty string)
- statCount(Q00.sgqa, submitted==false) error for expression manager :return "" (empty string)
- statCountIf(Q00.sgqa, submitted=true) error for expression manager :return "" (empty string)
- statCountIf(Q00.sgqa, submitted==true) error for expression manager :return "" (empty string)
- statCountIf(Q00.sgqa, submitted=false) error for expression manager :return "" (empty string)
- statCountIf(Q00.sgqa, submitted==false) error for expression manager :return "" (empty string)
- statCount('SID') : SID didn't exist in database, statCount('id') do the job
- statCount("SID") : SID didn't exist in database, statCount('id') do the job
- statCount('942944') : 942944 didn't exist in database, statCount('id') do the job WHY you think put surey id can return something ?
- statCount("942944") = (Hoping to see: number completed responses to this survey) previous
- statCount(942944) = (Hoping to see: number completed responses to this survey) previous
Then :
1. true is an invalid variable name : this break and send "" : it's a expression manager gloab issue, not related to statCount : use 1 or 1 == 1 etc …
2. false is an invalid variable name : this break and send "" : it's a expression manager gloab issue, not related to statCount : use 0 or 1 == 0 etc …
2. Usage of SID, 1234 etc ¿ are never documented, because this don't exist in database. It's teh same than use "ANYTHING' for DB column.
- statCountIf("LASTPAGE", 1) : fix by statCountIf("lastpage", 1)
- statCountIf("STARTLANGUAGE", "en") : fix by statCountIf("startlanguage", 1)
- statCount("COMPLETED") : fix by statCount("submitdate") , completed don't really exist.
- statCount("COMPLETED", true) : fix by statCount("submitdate", 1) , but same with statCount("submitdate")
- statCount("COMPLETED", false) : do not exist way tpo count whole OR completed : fix by {statCount("submitdate", 0) - statCount("submitdate", 1)}
- statCount("COMPLETED", all) : fix by statCount("submitdate", 0)Finally : there are no link between the 2 plugin. except you can use one plugin in another (to bet tested)
For example : «There are {statCountIf("startlanguage", STARTLANGUAGE)} particpa,nt started with the same language than yours ({STARTLANGUAGE})»
Hope is more clear.
The topic has been locked.