Support Center

Sharpen Reporting Tool

Last Updated: Apr 19, 2017 10:39AM EDT

Sharpen Reporting Tool

The Sharpen reporting tool is a powerful way to view and interpret detailed information pertaining to your individual interactions using the Sharpen application.

Data Source

The data source refers to the collection of data the user’s query will use to gather the desired parameters.  Queue activity refers to information specific to interactions that occur in a Sharpen queue.  The Agent activity field refers to information specific to the interactions of a specific Agent or group of Agents.  

Screen Shot 2016-11-29 at 9.53.14 PM.png







View

The view option allows you to select how the information will be displayed. The default view is “Table”. A Chart view is only available when Grouping is enabled.

Screen Shot 2016-11-29 at 9.58.19 PM.png

 

Timezone

The timezone selection allows for the system to correctly translate a UTC timestamp to the user’s local or desired timezone.  This is important to have an accurate reporting of anything related to time of day.

Screen Shot 2016-11-29 at 10.02.48 PM.png

Date Range

The date range is the amount of time the user’s query is targeting.  The system can use a preselected amount of time for its inquiry.  The user may also define the date and time, this is the Custom option, which allows the user to select specific dates both begin and end for the user’s query.

Screen Shot 2016-11-29 at 10.04.58 PM.pngScreen Shot 2016-11-30 at 5.40.45 AM.png

Report Fields

This section of the reporting tool allows the user to build what kind of information they want to run the query for in the Sharpen application.  A list of current fields that can be used in the query can be found here (link to dictionary).

Screen Shot 2016-11-29 at 10.34.06 PM.png

The Report Fields section allows the user to build custom queries.  Each fields location in the table is easily configured by clicking the button to the left of the field and drag n drop to change the order of fields that become visible after building the table.  The blue eye icon allows the user to target a specified field and omit it from the report without removing it from the list of desired fields.  The filter icon to the right of the eye icon allows the user to target specific information regarding the field it is next to.  Once the user has selected the filter icon, the options of Equals, Not Equal, Contains, Starts With, Ends with will become available to narrow down the search field.  Once all the fields have been selected, use the ‘Build’ button at the top right of the page to run the query.

Screen Shot 2016-11-30 at 5.40.57 AM.png

Limit

The limit function simply will limit the current query to the specified amount.  A value of 5000 will return up to but no more than 5000 results.  If the available total does not total 5000 it will simply return all values that match the query criteria.

Screen Shot 2016-11-30 at 5.38.53 AM.png

Sharpen Reporting: Advanced Options

Advanced Query

The Advanced query field option is built to allow users the ability to create SQL based queries to filter information.  There is no template for this Advanced feature, SQL knowledge is required to utilize this function.

Screen Shot 2016-11-29 at 9.51.56 PM.png

Derived Fields Manager

The derived fields manager is a simple way to build specifically targeted data.  Using the manager and basic SQL knowledge a custom field can be created and saved.  Once the query has been created it can be saved and stored for future reports.  

Screen Shot 2016-12-01 at 5.30.49 AM.png

Grouping

The ‘Grouping’ function explained, Coming Soon

Contact Us

53287620774b22021cc5dca627c0df84@fathomvoice.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete