Missing website category

[JoseOrosco]

Hi,

I have used the following dataset on my report and for some reason when i use it in a pie chart it shows missing as in the attached picture. Any idea of why it shows that?

select website, catdesc, sum(bandwidth) as bandwidth from (###(select hostname as website, catdesc, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from $log-traffic where $filter and hostname is not null and logid_to_int(logid) not in (4, 7, 14) and utmevent in ('webfilter', 'banned-word', 'web-content', 'command-block', 'script-filter') group by website, catdesc order by bandwidth desc)### union all ###(select hostname as website, catdesc, sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth from $log-webfilter where $filter and hostname is not null and (eventtype is null or logver=52) group by website, catdesc order by bandwidth desc)###) t group by website, catdesc order by bandwidth desc

Thanks in advance for the help.