How can I report on the sys_ui_navigator_history table using 'group by' function on a report?

[dustinh21]

How can I report on the sys_ui_navigator_history table using 'group by' function on a report? 

Essentially my main goal here is to understand our end user activity/usage of our PA Dashboards.  

I know that sys_ui_navigator_history shows when a user goes to a dashboard by the 'Title' field and I want to be able to group by 'Description' which shoes the name of the dashboard visited by the end use.

Below is the list view example showing that I cant use the group by function on any of the fields except for the 'User' field.  Description is a string field but so is short description on the INC table in which I am able to 'group by'  

[Mark Stanger · Accepted solution]

The difference is in the field lengths.  You can group by a string field as long as the field length is 255 characters or less.  Once you hit 256 or greater you can't group by that field anymore.  The Description field is 1000 characters.  I'd suggest creating a separate table to store the information you need for reporting and then set up a business rule on the Navigator history table to copy the necessary data to your custom table when the necessary conditions are met.

[dustinh21]

Thanks Mark! This all makes sense.