Dashboard: headline totals

Custom SQL query returning 1 row (hide)

SELECT
  (SELECT ROUND(SUM(qty_dest)) FROM trips)                      AS tonnage,
  (SELECT COUNT(*) FROM trips)                                  AS trips,
  (SELECT COUNT(*) FROM permits WHERE is_superseded = 0)        AS permits,
  (SELECT COUNT(*) FROM location_map)                          AS mapped_locations;

Edit SQL