Ok, I have rows of data, and each row has multiple decision booleans, which are progress criteria for a job completion.
My goal is to total the "true" booleans, and use this total to represent "amount done".
I struggled for three hours trying to figure out the correct syntax for this, searched the forum, nothing. I hit upon the solution quite by accident. So here is how you do it:
Say my project names are in string column "Project Names", and I have columns for "step 1", "step 2", and "step 3", which are all booleans.
Drag "Project Names" to the X-Axis.
Next, create an Aggregate Forumla and call it "progress", and in the formula definition, use:
- sumif("step 1"='true',1,0)+sumif("step 2"='true',1,0)+sumif("step 3"='true',1,0)
Once you have saved this formula, drag it to your Y-Axis.
Tada! Progress indicators. Use a bar graph for a nice representation.