Skip to main content
Solved

Exporting Filtered Data

  • Oct 23, 2023 7:56 PM UTC
  • 11 replies
  • 295 views

Forum|alt.badge.img+1

I’ve created a number of custom reports in Freshdesk Analytics with Filter widgets included, for example filtering by agent, status, or ticket type. I would like to be able to download the data with those filters applied, as the data appears in the UI. The current export is providing me with all data for the report as though filters were not being applied. Is downloading filtered data an option in Freshdesk?

Best answer by Sudhan R

Hi,

I understand that. you’re trying to export analytics with the filters applied.

Kindly try the following steps before you export the report.

 

  1. Open the required report
  2. Click on Edit from the right top corner
  3. Set the required filters
  4. Click on Save and then try exporting the same.

Please let us know if this works!

Happy Ticketing!

View original

11 replies

eeha0120
Top Contributor ⭐
Forum|alt.badge.img+12
  • Top Contributor ⭐
  • Oct 26, 2023 6:13 AM UTC

Hi.

Interesting finding.

If I understand correctly how Analytics works, these filters are applied only at GUI level, so, sadly, when exporting data, the whole dataset is exported.

However, I totally agree with you.

I’d suggest submitting this to Support as a bug; they might consider it a feature request, but defend your position.

If you decide to go with a request, submit the idea here in case it doesn’t already exist (Freshworks Ideas | Freshworks Community) and share the link so we could vote on it.

 

Regards,


Sudhan R
Community Debut
Forum|alt.badge.img
  • Community Debut
  • Answer
  • Oct 31, 2023 3:29 PM UTC

Hi,

I understand that. you’re trying to export analytics with the filters applied.

Kindly try the following steps before you export the report.

 

  1. Open the required report
  2. Click on Edit from the right top corner
  3. Set the required filters
  4. Click on Save and then try exporting the same.

Please let us know if this works!

Happy Ticketing!


A Whitaker
Community Debut
  • Community Debut
  • May 13, 2024 2:35 PM UTC

Sudan R’s recommendation works, this is literally the only mention I could find anywhere to deal with the default filter on export issue.


GeorgeHenry
Community Debut
  • Community Debut
  • May 14, 2024 3:14 AM UTC

you could explore integrating with third-party tools or APIs for more granular data extraction based on your specific filter criteria.


Yusuf Ahmed
Community Debut
Forum|alt.badge.img+8
  • Community Debut
  • May 14, 2024 10:40 AM UTC

Hi @A Whitaker,

Thank you for the update, The interactive filters applied are on the UI level to view the data applied with the filter and when you export it without saving, the export would contain the data without the filter.  However, I completely understand the importance of having access to filtered data for your reports.

To obtain filtered data in your exports, you'll need to save the report with your desired filters applied. Once saved, when you perform the export, the data will reflect the filtered view you've saved, providing you with the specific data set you need.

 

Regards,

Yusuf Ahmed


Forum|alt.badge.img
  • Community Debut
  • May 14, 2024 7:12 PM UTC

If I understand correctly how Analytics works, these filters are applied only at GUI level, so, sadly, when exporting data, the whole dataset is exported. \

great work - nicely defined and better help for needy persons  - 

To obtain filtered data in your exports, you'll need to save the carrom games with your desired filters applied. Once saved, when you perform the export, the data will reflect the filtered view you've saved, providing you with the specific data set you need.


Forum|alt.badge.img
  • Community Debut
  • May 15, 2024 8:57 AM UTC

If I understand correctly how Analytics works, these filters are applied only at GUI level, so, sadly, when exporting data, the whole dataset is exported. \

great work - nicely defined and better help for needy persons  - 

To obtain filtered data in your exports, you'll need to save the with your desired filters applied. Once saved, when you perform the export, the data will reflect the filtered view you've saved, providing you with the specific data set you need.


Amrit Mishra
Contributor
Forum|alt.badge.img+8
  • Contributor
  • May 15, 2024 9:22 AM UTC

We are currently working on a feature to honor the interactive filters in downloads. This capability should be available in an upcoming release.


Forum|alt.badge.img
  • May 15, 2024 11:38 AM UTC

o download data with applied filters from Freshdesk Analytics:

  1. Check if Freshdesk Analytics offers custom export functionality.
  2. Explore Freshdesk API for programmatically fetching filtered data.
  3. Consider third-party tools for advanced export capabilities.
  4. Manually extract data and apply filters using spreadsheet software if needed.
  5. Provide feedback to Freshdesk for potential feature updates.

Forum|alt.badge.img+2

Hello,

Our agents get regularly confused as well by the export behavior of the analytics reports tool. They spend time to filter required data but their filter is not taken in account upon export. They need to edit the report and save it in order to get the required extract. This is counter-intuitive and impacts other users of the same report.

I’m glad to read that taking into account the filter for analytic reports export will be part of a coming release, the sooner, the better :).


Amrit Mishra
Contributor
Forum|alt.badge.img+8
  • Contributor
  • Sep 25, 2024 6:06 AM UTC

@Sylvain Lebel please feel free to vote for this idea: Export underlying analytics data with interactive filters applied.