Contact Us

Arizona Public Service improves
operational performance and compliance
View the Case Study

    blue quote

    "DevonWay customer service is outstanding.  The project teams always provide quick responses."

    Claudette L., HU Section Head
    Canadian Nuclear Laboratories

      Case Study: Takeda

      At Takeda, DevonWay software
      contributes to 20% improvement
      in Batch Right the First Time.
      View the Case Study

        2 min read

        Four BI Calculated Fields for your DevonWay Reports

        Featured Image

        Using calculated fields in your reports will help you add useful information, organize your data, and get your questions answered. It’s easier than you may think, and we have a number of tutorials that walk through exactly how to do it. Here are four BI Calculated Field Functions you can try:

        1. The “Elapsed Days” Function

        Do you have questions regarding how long a task, assignment, or action has been open or overdue? Do you find yourself wondering, for example, how to easily view the average number of days it takes to close an item? Try using the Elapsed Days function to create calculated fields for Days Overdue, Days Until Due, Days Open, and Days To Close.

        2. The “Percent Of” Function

        Use the Percent Of function to calculate the percentage of overall total vs the percentage of a certain category for a count. Observations Performed is an example of a count, while Human Performance may be one of the attributes. This tutorial goes into more detail about how it works and how to set it up.

        3. The “DayName” and “Case” Functions

        Use days of the week to display your data and answer questions like: Are condition reports created equally throughout the week? When do most CR’s get closed? Watch this tutorial to learn how to set up and apply these functions to your job.

        4. The “Concatenate” Function

        Do you ever find that your reports are messy because there’s just too much information bunched together in one field? Try using this function to clean up large text fields while retaining all other fields.