Skip to main content
Implemented : Idea is live

Analytics - Possibility of 2 Metrics from differente Modules in same Widget - Cross Data from Tickets And Timesheets

Related products:Freshservice
  • August 28, 2023
  • 5 replies
  • 59 views

cmlouro
Apprentice
Forum|alt.badge.img+1

Hi, 

It was a major feature the possibility of crossing data from different metrics 

If we select a metric of “Timesheet” module (1), when adding 2nd metric (2) we only have available metrics inside the “TimeSheet” 

Example of Usecase: 

The use of Custom Fields in Tickets Module, like “Company” cannot be crossed by TimeSheet by Company, making it impossible to Know Hours for Billing by Company.

 

 

5 replies

Amrit Mishra
Community Manager
Forum|alt.badge.img+8
  • Community Manager
  • April 22, 2024

@cmlouro Is this still an issue? You should now be able to add metrics from across different modules to the same widget. Please see the screenshot below that shows metrics from 3 modules (Assets, Tickets, and Timesheet) added to the same widget. 

 


cmlouro
Apprentice
Forum|alt.badge.img+1
  • Author
  • Apprentice
  • June 24, 2024

Not an issue anymore, thanks for the new updates


alyssia.correa
Skilled Expert
Forum|alt.badge.img+8
New IdeaImplemented : Idea is live

Amrit Mishra
Community Manager
Forum|alt.badge.img+8
  • Community Manager
  • June 25, 2024

@cmlouro thanks for confirming. We’ll close this idea as it’s already implemented and available for use.


This is a really important limitation. As far as I’ve tested, most native analytics setups don’t support joining datasets across modules (like Tickets + Timesheets) within a single widget unless there’s a predefined relationship or shared schema.

A practical workaround is to handle this outside the system:

  • Export both datasets (tickets, timesheets)
  • Normalize them using a common key (e.g., agent ID, ticket ID, or time entries mapped to tickets)
  • Process or structure the merged dataset externally
  • Then re-import or visualize via dashboards

In some cases, even lightweight preprocessing (like cleaning, structuring, or standardizing text-based fields) makes a noticeable difference in how usable the final report becomes. I’ve personally experimented with small utilities (e.g., letras-diferente dot net) to normalize and format outputs before feeding them into reports, not a full data solution, but helpful for consistency and readability.

That said, native cross-module querying (or even a basic join capability in analytics widgets) would significantly reduce this overhead and make reporting much more powerful.