, "(SELECT COUNT(*) FROM Builds AS a WHERE me.project = a.project AND me.name = a.jobset AND a.isCurrent = 1 )"

      , "+as" => ["nrscheduled", "nrfailed", "nrsucceeded"]          

      , "+as" => ["nrscheduled", "nrfailed", "nrsucceeded", "nrtotal"]          

                  <th colspan="2">Success</th>

                  [% IF j.get_column('nrtotal') > 0 %]
                    [% successrate = ( j.get_column('nrsucceeded') / j.get_column('nrtotal') )*100 %]
                    [% IF j.get_column('nrscheduled') > 0 %]
                      [% class = '' %]
                    [% ELSIF successrate < 25 %]
                      [% class = 'red' %]
                    [% ELSIF successrate < 75 %]
                      [% class = 'orange' %]
                    [% ELSIF successrate <= 100 %]green
                      [% class = 'green' %]
                    [% END %]
                  [% END %]
                  <td>
                      <div class="[% class %]">[% successrate FILTER format('%d') %]%</div>
                      [% IF j.get_column('nrscheduled') > 0 %]
                          [% j.get_column('nrscheduled') %] builds still running
                      [% END %]
                  </td>
                  <td align="right">
                      <div class="[% class %]">[% j.get_column('nrsucceeded') %]/[% j.get_column('nrtotal') %]</div>
                  </td>

.red {
  color: red;
}
.orange {
  color: orange;
}
.green {
  color: green;
}