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

Metrics, Metrics, Metrics in PTC Integrity: Part 3

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

DevOps Visibility and Metrics for Driving Business Value eBook

DevOps Visibility and Metrics for Driving Business Value eBook

To reliably measure the business value of the software developmentprocess, organizations need better visibility across the softwaresupply chain. How do businesses improve DevOps visibility, and how does this drive business value? Find the answer to these questions and...

Related Resources

Leveraging Data Analytics Tools for Impactful Data Storytelling

Leveraging Data Analytics Tools for Impactful Data Storytelling

The ability to harness and effectively communicate the insights hidden within a company’s data has become a crucial skill for organizations. In a blog post from 2022, I explored the topic of storytelling through data utilization. This fusion of data analysis with...

Maximizing the Impact of PLM with Windchill+

Maximizing the Impact of PLM with Windchill+

Get ready to dive into a guide that will change your PLM horizons this year. In this free eBook brought to you by PTC and SPK and Associates, we are sharing how to maximize the impact of Product Lifecycle Management (PLM) with Windchill+.  In this eBook, you’ll learn...