Skip to main content
JoseOrosco
New Member
September 21, 2016
Question

Missing website category

  • September 21, 2016
  • 0 replies
  • 2303 views

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.

    Thought Leadership. Security Summit. Thursday, November 12th, PGA National Resort, Palm Beach Gardens, FL.
    Thought Leadership. Security Summit. Thursday, October 8th. Disney's Grand Californian Hotel & SPA, Anaheim, CA.
    Security Operations Summit: Modernize SecOps. Operate AI-Native.AMER: November 4 | 9:00 AM PST. India and SAARC: November 5 | 10:00 AM IST. EMEA: November 5 | 10:30 AM CET. APAC: November 5 | 11:00 AM SGT