This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Reports to TSV

FormerMember
FormerMember

I see in the documentation that when creating/running a report one of the options is to export it to TSV. Am I overlooking this? I don't see this option anywhere except the survey areas.

Thank you

  • you need to click on the gear then you will see download to TSV1390.jpg

  • FormerMember
    0 FormerMember in reply to amyd

    That’s not in the report view—that’s the ticket view. There’s currently no way to export report data—only the raw ticket data itself.

  • There are basically 2 different types of ticket reports -   the first is the 'normal' ticket report where you can choose "bar chart/pie chart/table only" and specify one or two ticket fields to cross-reference.  These are just exportable to .PDF.

    The other is "Billing Report", which primarily shows you the number of tickets and the amount of time spent on them... These are exportable to .TSV

    2016-03-31 14_34_04-Web Help Desk - Reports.png

  • Why can't we export ticket reports as TSV. Billing reports are far too limited for what we want to report on. Being able to export ANY report as TSV wouldn't seem to be too big an ask would it as the Ticket reports can already display a table of figures - that all we need.

  • You can get the data from a ticket report into a TSV with a bit of messing about.  If your report contains a table, you can click on the totals field of the table and that will display a list of the associated tickets.  You can then select them all and export them to TSV.