How to group values of a numeric field?
HappyFox BI allows you to custom group the values of a numeric field into buckets to help visualize the data across groups. For instance, Let’s say you want to view the total number of tickets whose first response time is within 0-5 hours and 5-10 hours respectively. The first response time field can be grouped in…
How to choose the appropriate Dataset for HappyFox Help desk data?
What are Datasets? All the data from the Helpdesk account gets moved to HappyFox BI after daily data sync and this data gets stored in different datasets. These datasets are ideally different data tables with unique columns stored in the database. Based on your reporting needs, you can choose the right data table/…
How to view and download the raw data behind a visualization?
The data used to build the visualization can be viewed and consumed for further analysis by downloading the same. Prerequisite: -> Create a Report and a Page -> Create a visualization and save it. Steps to be followed: To view the data: * Click the data blocks icon on the top right of the visua…
How to combine the values of a text field?
HappyFox BI allows you to combine the values of a text field values into groups to help you analyze them. For instance, let’s say you want to view tickets that are currently in 'Open' or 'In Progress' status against the rest of the other tickets, you need to combine all the ticket statuses except ‘open’, 'In Progr…
Back up or export of my helpdesk data
Currently through Tabular view report export, you can export all the ticket information including the client's initial message and subject of the email. However, please note that you will not be able to export the staff/client replies that are updated after the initial message and private notes of a ticket. In…
