Postgres queries that return values of type
select count(*), avg(tally) from records;
count() aggregate function returns bigint, and
avg() returns numeric for integer arguments. If you try to display these using the Statistic component it shows an error, because the input is a string, not a number. I can manually cast these to other types (integer or double precision) either in the query or using
parseFloat, but that is rather cumbersome.
Thank you for the great product!