Purpose

1. This article will review the Ad-Hoc Columns Information within the Reports module. 
   

---

Information

1. This page contains all data that you can import into your columns from which has been selected in the Data Source Configuration Tab

Selecting Your Data Columns 

1. Here, you can select the columns you want to see in your report. 
   
2. For this example here, we are using Incident ID, PSAP Time; Incident Type, and Fire Station Name
   
3. Once you have selected the columns you wish to use, you must select the "+" as seen below to add them to your report. 

---

Organizing Your Columns

1. Once you have selected your data, you can rearrange the order of these columns. The way you sequence them will directly affect the order in which the columns appear in the report.
   
2. Additionally, You can control the name of this column by using the pencil icon. For example, if you want to rename “PSAP Time” to “Dispatch Time,” you can do that, and the new column name will appear as “Dispatch Time” in the report.

---

Understanding Custom Columns

1. Within the columns section, there may not be a dataset that is available, in this case you can add a custom column. The operations it supports are:
   
1. Concatenation 
   
2. Sum 
   
3. Subtract
   
4. Multiply 
   
5. Divide
   
6. Date Time Difference 
   
7. Date Difference
   
8. Time Difference
2. You can add a custom column by selecting the option at the bottom of the column list. After selecting, you can name the custom column and choose from a list of operations to define its functionality.
   
3. It is important to be mindful of the order in which operations are performed when configuring custom columns, particularly when dealing with time intervals. Incorrect configuration can lead to negative or incorrect results, especially when calculating time differences across time. Further, The system is designed to recognize that mathematical operations can only be performed on numeric data types. Therefore, columns containing text data types will not be available for selection when performing math-related tasks.

1. EXAMPLE: To better understand this; we are going to build a report to calculate the total time the unit was committed to an incident, which includes the time from when the unit was en route to the scene and the time from arrival at the scene until the unit cleared. We will build one that shows both in seconds and time difference. 
1. Create a custom column by summing the “Enroute to Scene” time with the “Scene to Clear” data sets. 
   
2. Give your custom column a title; in this case, it will be "Utilization Time - Seconds"
   
3. Add in the operation of "Sum" and then the data we are calculating.
   
4. Select the update Column to save. 
   
   
5. Next, perform the same actions but title your Custom Columns "Utilization Time - DHM"
   
6. Then select the operation of "Date Time Difference" 
   
7. The Data to pull would be "Arrive At" & "Dispatch Acknowledged" 
   
   
8. Select Update Colum and the report will show you the total utilization time