Last updated: 2024-10-22

Source: https://support.freshdesk.com/support/solutions/articles/50000001030-applying-filters-at-a-widget-level-in-analytics

Applying filters at a widget level in Analytics

You can filter reports and widgets using the following criteria:

Based on a particular time period or a custom date range, this will help you understand your helpdesk metrics on a day-to-day basis and help you keep an eye on overall performance.

Based on ticket properties like type, source, priority, agent, group, and customer or custom ticket fields. You can identify specific channels or areas of your helpdesk that require focus and allocate resources accordingly.

Based on knowledge base article properties like author, category, folder, language, and more. This helps you identify your articles' effectiveness and how well your content team is performing. To learn more, click here.

Based on tags \- if your team uses tags to track specific issues or events, filtering your reports by tags will make it easier to understand the main issues that affect your performance and provide insights into finding long-term solutions for those issues.

Based on use case, you can apply Basic or Advanced filters and use ANY/ALL conditions.

Setting up widget filters

  • Log in to your support portal.
  • Click the reporting icon and choose Analytics.
  • Click on New Report near the search bar. Give it a title, set the required visibility, and click on Create.
  • You will be able to view the widget library on the right panel. If you cannot see the panel, click on icon to display the widget library.

  • Once you drag and drop a widget, click on the widget to go inside the configuration page.

    • For example, you want to see the ‘ Total tickets grouped by status’ when the source is email, and the requester language is french for tickets created in the last 30 days. This is what you need to do:

  • Drag and drop the ‘ Total tickets grouped by Status’ on the report canvas. Click on it to go inside the widget.

  • Click on  icon.

    • SR3 - edit date in the widget filter

    Note: After typing the number in the filter tab, press Enter to make the time period dropdown appear.

  • Now, click +filter
  • After placing the cursor on the tab, select Source from the dropdown. Then, select is and email from the subsequent dropdowns.
  • Similarly, click +filter again, select requester language as fr.
  • Click Apply

    • SR 4 new

    Note: You can create as many basic filters as you want.

    You will see an ALL/ANY condition filter appear above. Only the tickets that satisfy both conditions will appear if you select ALL. If you select ANY, the tickets that satisfy either of these conditions will appear. Once you decide on a condition, click Apply.

    The widget canvas will automatically load in the best visualization format which you can change anytime. You will also be able to see the underlying data. If you’re okay with the widget configuration, click Save, which appears near the title.

    Applying advanced widget filters

    If you want to apply filters with both ALL and ANY condition, you can make use of Advanced filters. For example, if you want to find the average time spent by the agent on social media tickets in the last 7 days, here’s how you can do it:

  • Drag and drop ‘ Avg time spent by agent’ from the widget library.
  • Once the widget loads, click on it to go inside the widget.
  • Click on  icon.
  • Click +filter
  • After placing the cursor on the tab, select Source from the dropdown. Then, select is and facebook from the subsequent dropdowns.
  • Similarly, click +filter again, and select Source is email.
  • Select ANY condition.
  • Now, click on Advanced filters.
  • Click +filter group. Enter created date in the last 7 days. (After entering any number in the filter, press Enter to get the next dropdown) Set the overall condition that connects the filter groups as ALL.
  • Click Apply

    • Note: The ALL/ANY condition present at the top connects filter groups as a whole. The ALL/ANY condition present inside is for the filters present inside each group.

    Now, if you want to find the agents who have spent the maximum time on social media tickets in the last 7 days, you can use Rank Order. Here’s how:

  • Click on +rank order
  • Select Top from the dropdown. Then, select 5 from the number dropdown and click Apply.

    • This will give you an idea of which agents are underperforming. Click Save present near the widget title. Similarly, you can find the bottom order and also modify the number you want to view.

    Click here to learn how to set up multiple metrics in a widget.

    Sorting in widgets

    You can sort widgets based on the following criteria:

  • Ascending: Sort widgets from the lowest to the highest value (e.g., alphabetical or numerical order).
  • Descending: Sort widgets from the highest to the lowest value.
  • Custom sorting: You can arrange widgets according to specific values, such as urgent, high, medium, and low.

    • You can also sort based on metric data. For example, if the metric you’ve created is Total tickets created, then you can sort the widget in two ways:

  • Total tickets created - Ascending: Sort widgets from the lowest number of tickets created to the highest.
  • Total tickets created - Descending: Sort widgets from the highest number of tickets created to the lowest.

    • ``` Note: This feature is available only for English (Users with English as the language chosen in Freshdesk). ```