Peliqan Logo
Login
Request a demo

Freshdesk

Agent Performance

SQL query for Freshdesk

Get the average response time and resolution time by agent.

SELECT agent_id, AVG(response_time), AVG(resolution_time) FROM tickets_conversations GROUP BY agent_id

Try this query now in Freshdesk

Freshdesk data model

Freshdesk
Table Accounts

Freshdesk
Table Agents

Freshdesk
Table Contacts

Freshdesk
Table Companies

Freshdesk
Table Email Configs

Freshdesk
Table Email Mailboxes

Freshdesk
Table Groups

Freshdesk
Table Products

Freshdesk
Table Roles

Freshdesk
Table Surveys

Freshdesk
Table Tickets

Freshdesk
Table Tickets Conversations

SQL - Combine data

Magical SQL for Freshdesk with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

  • PBI LogoCreated with Sketch. Power BI
  • Metabase
  • Tableau

Let AI do the work for you

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Peliqan Overview

Ready to get instant access to
all your company data ?

Book a demo