I have a record which contains a checkbox. When aggregating the object type I would like to count the number of times that box appears checked.
I tried using a SUM and a COUNT and it appears the checkbox field is not supported in those capacities in SKUID. As a work around I decided to create a Formula Field (Number) that would be either 0 or 1 depending on if the value of the box was checked. Unfortunately it appears that SKUID aggregates do not support formulas.
Aside from using APEX or field updates to populate a Number field is there a better way that I am not identifying to count fields which are checked in Aggregates?
I tried using a SUM and a COUNT and it appears the checkbox field is not supported in those capacities in SKUID. As a work around I decided to create a Formula Field (Number) that would be either 0 or 1 depending on if the value of the box was checked. Unfortunately it appears that SKUID aggregates do not support formulas.
Aside from using APEX or field updates to populate a Number field is there a better way that I am not identifying to count fields which are checked in Aggregates?