Contact Us
Quaker Houghton logo for customer page

How Ideagen helped Quaker Houghton
streamline systems to connect
workers across the globe
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

        How to Use Reporting to Find Common Causes

        Featured Image

        Cause analysis charts are easy to set up in your DevonWay application and will help you effectively analyze and communicate your data. In this exercise, we’re going to walk through the steps for how to create one by using 10 employees with the most overdue condition reports as a case study.  

        1. Create a new crosstab report

        2. Filter out Closed and Cancelled CR’s, as well as those in Initiate 

        3. Add a filter on the Need-by or Due Date field, selecting the Today or Before dropdown option 

        4. Add the Assigned To field as a row 

        5. Add the Count measure as a Column 

        6. Right click on the Count column heading, then select Sort Descending

        7. Right click in the same area and select Filter Top N Values 

        8. Enter 10 and de-select the Show aggregate of unranked values checkbox. NOTE: Leave this selected if you want all values not within the top 10 to be summarized into an eleventh element 

        9. Change the report type from Crosstab to Chart 

        10. If needed, adjust the Data Level Rows slider 

        11. Consider changing the chart to a column chart so that the names are easier to read

        When you apply these steps to your personal use case, remember to first sort your data by the desired field in Crosstab, then switch to chart

        Was this helpful? 

        We are always looking to improve our training materials. If you have any feedback on this particular tutorial or have another documentation suggestion, please reach out to marketing@devonway.com.