The steps below will walk you through the basics of creating a BI report in JobTraQ reporting software. The end result will be a report shows a list of tasks that have reached the high alert level and who is assigned to them.

  1. Click on the Business Intelligence tab under the Report page and click on Add a New Report. You will be on the page where you design the report.
  2. Under the Data panel, you will select two check boxes. There are “Jobs” and “Job Contact Names”
    BI Data
  3. Click Next Step to go the Ordering panel. Here you will add the fields that you want to order the list by. In this example, I have selected the Assignee Names and the Task ID and give the steps below for that. You can feel free to add any other ordering.
    1. Select the field “Job Contact Names.Assignee Names” from the drop down list. It will be all the way at the bottom. Click the blue diskette button to save the list.
    2. Select the field “Jobs.Id” from the drop down list. Click the blue diskette button to save the list.
      BI Ordering
  4. Click Next Step to go to the Parameters panel. This panel is an important because you can limit the list to the parameters such as any cases open cases with a high status.
    1. Click Add a Parameter and select Jobs. Alert Level. Set it equal to High
    2. Click Add a Parameter and select Jobs.Status and set it Not equal to Completed.
      BI parameters
  5. Click Next Step to go to the Column Configuration panel. This will allow you to select columns to the display on the report.
    1. Click Add Column and add the following fields by selecting and clicking the right facing arrow
      1. Job Contact Names.Assignee Names
      2. Jobs.Id
      3. Jobs.Brief Description
      4. Jobs.Status
    2. Click Ok
      BI columns
  6. At this point, you give the report a good name and click the Preview Report button. If it appears correctly, go ahead and save it. You can always come back and edit it or add more parameters if necessary. Below is a screenshot of the final report
    BI example

Take Control of Your Business Processes

With JobTraQ your business processes are controlled, measured, and continuously improved. Allowing you and your organization to enjoy new levels of success. What are you waiting for?

Request a Demo or Call Us +1.866.640.CODE (2633)