diff options
| author | Mark Wells <mark@freeside.biz> | 2015-02-18 15:50:45 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2015-02-18 15:50:45 -0800 |
| commit | e11f3188435b30c193fd1443913ed77953e14dea (patch) | |
| tree | 08ed3c81d12e89973e591103e34df9f4f1a2d173 /FS/FS/Report | |
| parent | dba9a62fa32e07d4461e9c081201f69c0cda7015 (diff) | |
use media type codes in broadband subscription report, #28020
Diffstat (limited to 'FS/FS/Report')
| -rw-r--r-- | FS/FS/Report/FCC_477.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/FS/FS/Report/FCC_477.pm b/FS/FS/Report/FCC_477.pm index c93c919..75ddee0 100644 --- a/FS/FS/Report/FCC_477.pm +++ b/FS/FS/Report/FCC_477.pm @@ -400,7 +400,8 @@ sub fbs_sql { my @select = ( "$censustract AS censustract", - 'technology', + '(technology - technology % 10) AS media_type', + # media types are multiples of 10 'broadband_downstream', 'broadband_upstream', "SUM($q)", |