Unfortunately I couldnt get it to work. @Kevin-C any thoughts?
This is what I have so far but the results just display 0
{% set rows = hubdb_table_rows(1234567) %}
{% set num_car = rows | selectattr (“transport_type”,“equalto”,“Car”) | length %}
{% set num_train = rows | selectattr (“transport_type”,“equalto”,“Train”) | length %}
{% set num_bus = rows | selectattr (“transport_type”,“equalto”,“Bus”) | length %}
{% set num_bike = rows | selectattr (“transport_type”,“equalto”,“Bike”) | length %}
<table>
<tr><td>Number commuted by car:</td><td>{{ num_car }}</td></tr>
<tr><td>Number commuted by Train:</td><td>{{ num_train }}</td></tr>
<tr><td>Number commuted by Bus:</td><td>{{ num_bus }}</td></tr>
<tr><td>Number commuted by Bike:</td><td>{{ num_bike }}</td></tr>
</table>