Hi @hughrmarks
One way to do this is to add your variables to a table. In the example below, the Table function creates a table with 5 rows. The column name is 'Variable' and each row in the table corresponds to a vLabelX variable.
You can then call the CountIf function and specify a condition to return a row count.
The formula to return a count of red labels would look like this:
CountIf( Table({Variable:vLabel1},{Variable:vLabel2}, {Variable:vLabel3},{Variable:vLabel4},{Variable:vLabel5}), Variable=true )
The formula to return a count of blue labels would look like this:
CountIf( Table({Variable:vLabel1},{Variable:vLabel2}, {Variable:vLabel3},{Variable:vLabel4},{Variable:vLabel5}), Variable=false )
Hi @hughrmarks,
I agree with @timl's thought almost, I have made a test on my side and my app's configuration as below:Add a Label control within your screen, the Text property of it set to following formula:
"Red="&CountIf( Table({Variable:vLabel1},{Variable:vLabel2}, {Variable:vLabel3},{Variable:vLabel4},{Variable:vLabel5}), Variable=true )&", Blue="&CountIf( Table({Variable:vLabel1},{Variable:vLabel2}, {Variable:vLabel3},{Variable:vLabel4},{Variable:vLabel5}), Variable=false )
Best regards,
Kris
User | Count |
---|---|
172 | |
90 | |
74 | |
70 | |
58 |
User | Count |
---|---|
215 | |
160 | |
98 | |
92 | |
73 |