fbpx
1-888-310-4540 (main) / 1-888-707-6150 (support) info@spkaa.com
Select Page

Metrics, Metrics, Metrics in PTC Integrity: Part 3

windchill features best plm software
Written by SPK Blog Post
Published on March 3, 2015

In my previous articles, I discussed how we can calculate trace report metrics, and then gather them into a report. In this report, I am going to discuss how we can gather similar metrics and put them into a chart format. This time though we are going to use a field called Trace Status and chart what items have upstream, downstream as well as items that have horizontal traces. The particular chart we are going to build is going to retrieve all the Design content items in the database, and then chart them based on the selected Trace Status Value. The chart we are going to build will look as follows:

Like the report in the previous article, the chart will perform the following activities:

  1. It performs a query on the database to retrieve all of the Design items currently in the system.
  2. It then groups those results by the selected Trace Status values
  3. Then it presents the results as a pie chart.

Next I will take you step by step through the process of building this chart.  Perform the following steps to build this chart:

  1. From the main menu bar on your Integrity Client select Chart -> Create… to create a new Chart on your system.  If the “Chart” menu or the “Create…” does not exist, you may have to customize your ViewSet to make it visible.  The “Create Admin…” option should only be used if you are a member of the Administrator group and you are looking to build a system based chart that will be used across the entire Integrity instance.  In this case I just want to build the Chart for myself and maybe my teammates. SPK Metrics 1
  2. This will open the Create Chart dialog from which you can create your new Chart. SPK Metrics 2
  3. Provide a name for your report, which is how it will be known across the system, a title and a description. SPK Metrics 3
  4. Next we will go to the sharing tab, select the “Choose Principals…” and select to whom we would like to share the chart with.  You can select specific individuals or groups to whom you could potentially share your chart with. Some Integrity systems may be configured to prevent end users from sharing your new chart globally through the “Everyone” group. SPK Metrics 4
  5. The select users and groups in the Shared with list, at this point only able to View the chart in question.  By selecting on the “Modify” checkbox, I have allowed anyone in the Administrator’s group to have modify privileges on the Chart. SPK Metrics 5
  6. Next select the Query tab.  From the query dropdown list type “Design” into the “Show queries containing filter” to more easily find the “Designs” query.  The Designs query is a system designed query provided with the Med Device Solution.  This query will be used to retrieve the items we are going to chart. SPK Metrics 6 SPK Metrics 6a
  7. The next tab is the Project Filter tab.  By applying a project filter to your chart, you can restrict the items filter out the items displayed in your chart based on the selected project values.  In this case we are simply going to leave this blank. SPK Metrics 7
  8. The next tab is the Charting Values tab.  In this tab we specify the field we wish to chart, as well as the values we wish to represent within the chart.  In this case we will be charting the field “Trace Status” and we will be selecting every possible value that can be represented in that field. SPK Metrics 8
  9. The next thing we are going to do is to deselect the “Show Zero Count Values” check box. This means that the new chart we create will only chart the values where it has values to report, in this case helping us de-clutter the overall chart. SPK Metrics 9
  10. The last tab is the Graph tab. In this tab we can select the type of chart we want to display, whether to display it in 3D or not.  You can also define your own custom colors, as well as entitling the legend. In this case we are going to go with a two dimensional pie chart, with only the standard colors, and with the Legend entitled as follows: SPK Metrics 10
  11. Finally select OK to create the chart.
  12. Once the chart has been created you can run the chart from the Manage Charts window.  You can open this window by selecting the menu Chart -> Manage Charts SPK Metrics 12
  13. This will open up Manage Charts window in the Integrity Client, and from there it is a simple matter to run the desired chart: SPK Metrics 13
  14. And the Final report, of course looks like this:

This chart is just one example of what you can do with charting in PTC Integrity.  If you were to couple this report with similar reports across all of your PTC Integrity documents you can get a complete picture of what your system looks like.  Not to mention that if you were to select any individual piece of the pie chart above you can drill down to the items that make up that slice. In my next blog article I am going to discuss how you can pull together Reports, Charts and even saved queries into more comprehensive dashboards that will present data in a fast and easy way for an overall interpretation of your product under development. Next Steps:

Latest White Papers

Guide to work management: Tools for teamwork

Guide to work management: Tools for teamwork

Ensuring collaboration between cross-functional teams can be challenging, especially when these teams are global. Fortunately, there are many tools on the market that mitigate these struggles. Atlassian’s suite of tools helps teams across the globe collaborate like...

Related Resources

Tackling Cultural Resistance to Enhance Data-Driven Decision Making

Tackling Cultural Resistance to Enhance Data-Driven Decision Making

Adopting a data-driven approach is essential for companies seeking to enhance decision-making and drive growth.  However, one of the biggest obstacles to achieving this is cultural resistance. This resistance is often from HiPPOs (Highest Paid Person's Opinion), who...