WSS Reports showing multiple category fields (category and categories) with different values
search cancel

WSS Reports showing multiple category fields (category and categories) with different values


Article ID: 240284


Updated On:


Cloud Secure Web Gateway - Cloud SWG


Administrator created a new report, summarising by Category and then Site as shown below

Filtered on ALL dates and the rest of the selections left to default.



When it ran, it showed the category and site information, but also included  a 3rd column called "Categories". Although a lot of the information overlaps with the Category field, some entries are down as different categories  e.g. the Office/Business Applications category includes a site with a Search Engine/Portal categories?





WSS Reporting


When running a two level report ("Category" + "Site"), the report will always show the top categories. It then breaks down the Category into the top Sites seen in that Category.

Additionally, there is also a special metadata column called "Categories".  This field is automatically added to most reports that have the "Site" field.  The "Categories" column doesn't show data from the web logs, and this is confusing.  Instead, it shows the current list of categories from Web Pulse for the "Site" displayed on this row.  The idea is to provide the user some context.  If a row has a site named and the user hasn't ever heard of that website, the current Web Pulse category can provide some context to help the customer.  However, the report is very confusing if the report contains both the "Category" column (based on the customers logs) and the Categories column (metadata about the Site).



Although somewhat confusing, this report is working as designed.

The "Categories" column in 2 level reports includes metadata from other sources to provide more context to the admin.