# Reports ## Overview As many things are in XReach, the Reporting system is configurable and customizable by a **GroupAdmin**. At the time of writing this, the Report view can provide you with a possibility to download the following reports: **UserCountReport**, **CustomFormCall**, **CustomFormMissedCall**, **CustomFormTicket** , **AdHocReport** and **AllUserReport**. All downloaded files are in the standard Text file format (.txt), but can be modified by the user in a standard text editor and saved into the .csv file format and accessed with **Microsoft Excel** / **Google Sheets** or **Numbers** by Apple. ## Accessing Reporting As a **GroupAdmin**, you are the only person able to access the **Reporting** feature. It can be accessed via clicking on the **Cog** and then **Report**, as shown below. ![How to access the Report feature](https://4219527844-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMPaHg7zC9PGFTMjK1L%2Fuploads%2FIDTiipmjCEYPdBqVw93d%2FScreenshot%202022-06-23%20at%2004.40.jpg?alt=media\&token=c10ff2ec-400d-44a1-ad05-0511912b5874) After clicking on the **Report**, you will see an image similar to the one below, depending on the configuration of your organization. Select the Report that you want, set the **Starting month** and **Ending month** of the report and press the **Download** button, upon which you will be sent a textfile containing the report of your choice with the duration of your choice. If there is no Start & End Date, clicking on the **Download** button will suffice. ![Reports page](https://4219527844-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMPaHg7zC9PGFTMjK1L%2Fuploads%2FS3vl7k0mdoBvg0AXuREu%2FScreenshot%202022-06-23%20at%2004.42.png?alt=media\&token=d2e66326-b9ed-4998-a02b-bc07c4515f18) As an example, you would receive a file such as this: ![file name](https://4219527844-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMPaHg7zC9PGFTMjK1L%2Fuploads%2FUz4dlUJxaAKw6tau3DCh%2FScreenshot%202022-06-23%2007.16.28.png?alt=media\&token=37099917-4fef-475c-942d-802ca1eb487b) Open it with your standard text file editor, and hack away at the data. ## UserCountReport Here is a very bare bones example of what the **UserCountReport** may look like. ``` Total user count : 3 Created user count : 1 Active user count : 1 Deactive user count : 1 Deleted user count : 1 Index,FirstName,LastName,Email,Permission,AccountState "1","Example","User","exampleuser@imaginary.address","Expert","Active" "2","Example","User2","exampleuser2@imaginary.address","GroupAdmin","Deactive" "3","Example","User3","exampleuser3@imaginary.address","RemoteUser","Created" ``` #### Quick details of the UserCountReport * A Created account has not yet been activated. * An active account has been activated. * A deactive account has been deactivated. * A deleted account has been.. you guessed it.. deleted. No details of this account will be shown, but the Deleted user count will be increased and the Total user count decreased. ## AllUserReport Here is an example of how the **AllUserReport** may look like. ![All User Report](https://4219527844-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMPaHg7zC9PGFTMjK1L%2Fuploads%2F7Dj1CEQEycGcJD1ksG9M%2FScreenshot%202022-06-23%2008_26_32.png?alt=media\&token=01440c32-eb6e-4ef0-86a8-e34afcfad765) As you can see from this, report shows the details of all the user's FirstName, LastName, Email, Permission, Group, Account State, Country and Organization. ## AdHocReport Here is a very bare bones example of what the **AdHocReport** may look like. ![Ad Hoc Report](https://4219527844-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMPaHg7zC9PGFTMjK1L%2Fuploads%2FEC8HvqXYEDmfDDUEbdqE%2FScreenshot%202022-06-23%2007.24.51.png?alt=media\&token=182bd94b-a399-4fab-b534-cf85b83b0c0b) As you can see from this, the level of Ad Hoc Reporting, as of now, can show the date of creation of an **Ad Hoc User**, **Email**, the **Maximum Amount of Logins**, **Used Logins**, and a **Price** for the calls. ## CustomForm Reporting {% hint style="danger" %} It is important to understand that the **GroupAdmin** will only be able to download reports of tickets that are in the **Groups** that the **GroupAdmin** is a member of. If other **Groups** exist in your environment, you will only get **CustomForm Reporting** information from them if you ask other **GroupAdmins** to add you to those **Groups**. {% endhint %} ### CustomFormCall Upon opening the textfile, you will see something similar to this example file. ![Custom Form Call](https://4219527844-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMPaHg7zC9PGFTMjK1L%2Fuploads%2FMzBcGCHUAFqfp8NlaUWE%2FScreenshot%202022-06-23%2007.32.00.png?alt=media\&token=a1f9bf93-e861-4c8d-8761-3ed2f5633046) This report shows you the overall activity, within the selected time period, of calls, which ticket they are originating from, and how many there are. If a **Remote User** in Finland creates a ticket, and this ticket is called by any **Remote User**, then the calls will be listed as being from the country of Finland. ### CustomFormMissedCall Upon opening the textfile, you will see something similar to this example file. ![Custom Form Missed Call](https://4219527844-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMPaHg7zC9PGFTMjK1L%2Fuploads%2FBDmV9rIxtHzvhtjU74KB%2FScreenshot%202022-06-23%20at%2005.18.png?alt=media\&token=ee16acf6-0545-40bd-952c-400ef61909aa) This report shows you how many missed calls a certain ticket is getting, i.e., if an **Expert** is not answering the calls at all, you can train them so they are better able to solve the issues, or find a person that is better able to address the issue at hand. ### CustomFormTicket Upon opening the textfile, you will see something similar to this example file. ![CustomFormTicket](https://4219527844-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMPaHg7zC9PGFTMjK1L%2Fuploads%2FxXV5GaiGTHFvPSVVsIdf%2FScreenshot%202022-06-23%2007.51.14.png?alt=media\&token=7cc07ebe-8df6-4b87-bab7-86b062c7f7aa) This report shows you the overall activity, within the selected time period, of tickets that are being reopened, and how many times they have been reopened. This assists in figuring out if there are problematic tickets with non-applicable / non-useful solutions, or if there should be additional training for the **Expert** to better be able to solve the issues, or if it is a repetitive issue with a specific device. ## Opening a Report in Excel Now that you have your textfile, it would be intriguing to see the CSV-formatted data in Excel, wouldn't it? For this, you will need to isolate the textual data and save them as separate CSVs. As an example, you could use the CustomFormCall data. Select the following lines and copy and paste them to a file and save it with the .CSV file extension ![CustomFormCall](https://4219527844-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMPaHg7zC9PGFTMjK1L%2Fuploads%2FkM8QW0F9JmSDP4wpz0PG%2FScreenshot%202022-06-23%2007.32.00.png?alt=media\&token=68039b9a-8eee-4384-bddf-a33004700d2c) After saving the data as a separate file in the .CSV format, you can open it in your preferred spreadsheet application - below you will see what they look like on **Windows Numbers**. ![CustomFormCall loaded into Numbers](https://4219527844-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMPaHg7zC9PGFTMjK1L%2Fuploads%2FTRXNHudeMR5wH7vykyHt%2FScreenshot%202022-06-23%2008.15.26.png?alt=media\&token=0aad1446-c625-4279-9b0e-892192b65823) Questions? Please email .