{"id":221,"date":"2021-01-15T14:42:05","date_gmt":"2021-01-15T22:42:05","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/?p=221"},"modified":"2021-01-15T14:52:34","modified_gmt":"2021-01-15T22:52:34","slug":"wpa-table-graph-configurations-part-1","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wpa-table-graph-configurations-part-1\/","title":{"rendered":"Windows Performance Analyzer &#8211; Table &#038; Graph Configurations (Part 1)"},"content":{"rendered":"<p>In the <a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wpa-intro\/\">previous post<\/a>, we discussed a brief intro into Windows Performance Analyzer (WPA) and its feature set.\u00a0 WPA can display trace data in a wide array of formats, most of which are pre-configured as presets designed for drilling into specific data points.<\/p>\n<p>Here is one for example: WPA&#8217;s <em>CPU Usage (Sampled<\/em>) table has a few different presets, each reconfigures the view of both table and graph data.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/CPU-Usage-Sampled-Presets.png\"><img decoding=\"async\" class=\" wp-image-224 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/CPU-Usage-Sampled-Presets.png\" alt=\"Image CPU Usage Sampled Presets\" width=\"508\" height=\"358\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/CPU-Usage-Sampled-Presets.png 838w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/CPU-Usage-Sampled-Presets-300x212.png 300w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/CPU-Usage-Sampled-Presets-768x542.png 768w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/a><\/p>\n<p>This blog post is the first of a multi-part series that goes into detail on how to configure the table and graph views to create your own presets:<\/p>\n<ul>\n<li><strong>Configuring column options for tables (Aggregation\/Format\/Sort\/Text Alignment) &#8211; Part 1<\/strong><\/li>\n<li>Configuring columns for graphing (Line\/Bar\/Gantt) &#8211; Part 2<\/li>\n<li>Quick saving presets and profiles &#8211; Part 3<\/li>\n<\/ul>\n<h3>Column Options<\/h3>\n<p>Depending on the column&#8217;s data type, WPA can configure each column with one or more of the following options:<\/p>\n<ul>\n<li>Aggregation<\/li>\n<li>Sort<\/li>\n<li>Format<\/li>\n<\/ul>\n<p>Each set of options can be configured by either <a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/test\/wpt\/change-column-properties#right-click-context-menu\">right clicking on the column header<\/a>, or visiting the <a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/test\/wpt\/view-editor\">View Editor<\/a>. Let&#8217;s dig into what each one of these options mean and the different ways to configure them.<\/p>\n<h4>Aggregation<\/h4>\n<p>When combined with the Pivot (Gold) Bar, can be powerful tool in understanding large data sets at a glance.\u00a0 WPA will calculate the selected aggregation of all individual rows inside the pivot group on the fly as you expand\/collapse, filter row data, and adjust the timeline zoom.<\/p>\n<ul>\n<li>Average (Avg)<\/li>\n<li>Count<\/li>\n<li>Max<\/li>\n<li>Min<\/li>\n<li>Sum<\/li>\n<li>Unique Count<\/li>\n<li>Weighted Average (Weighted Avg)<\/li>\n<\/ul>\n<p>As an example: open a trace captured with <em><a href=\"https:\/\/docs.microsoft.com\/en-us\/previous-versions\/windows\/it-pro\/windows-8.1-and-8\/hh448134(v=win.10)\">WPR&#8217;s General Profile<\/a><\/em> and expand &#8216;System Activity&#8217; and &#8220;double click&#8221; the <em>Process Table<\/em> in the &#8216;<a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/test\/wpt\/introduction-to-the-wpa-user-interface#graph-explorer-window\">Graph Explorer<\/a>&#8216;.\nIn the below table screenshot has aggregations applied to three different columns: Duration [Sum], Start Time [Min], and End Time [Max].\u00a0 For each pivot\/group to the left of the gold bar, the rows are calculated based on the aggregation selected. In the below table screenshot, &#8216;Transient&#8217; is expanded to show the aggregated values for each sub group.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/Table-Aggregations.png\"><img decoding=\"async\" class=\"wp-image-227 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/Table-Aggregations.png\" alt=\"Image Table Aggregations\" width=\"766\" height=\"383\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/Table-Aggregations.png 1104w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/Table-Aggregations-300x150.png 300w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/Table-Aggregations-1024x512.png 1024w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/Table-Aggregations-768x384.png 768w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/a><\/p>\n<p>Each column can be configured with a different aggregation, which is especially useful for views that incorporate CPU, Memory, and Disk usage. The best way to get a feel for the power of aggregations is to open a table and play around with changing column aggregation modes and expanding\/collapsing pivot groups.\u00a0 So before continuing, I encourage you to jump in and try things out!<\/p>\n<h4>Sort<\/h4>\n<p>Columns in tables can be quickly sorted by clicking the column header. If you would like to sort the data based on it&#8217;s absolute value, simply hold CTRL key while clicking while clicking the column header to toggle.<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 25%; text-align: center;\">Ascending<\/td>\n<td style=\"width: 25%; text-align: center;\">Descending<\/td>\n<td style=\"width: 25%; text-align: center;\">Ascending (Absolute)<\/td>\n<td style=\"width: 25%; text-align: center;\">Descending (Absolute)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 25%;\"><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Ascending.png\"><img decoding=\"async\" class=\"size-full wp-image-242 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Ascending.png\" alt=\"Image WPA Weight Ascending\" width=\"126\" height=\"304\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Ascending.png 126w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Ascending-124x300.png 124w\" sizes=\"(max-width: 126px) 100vw, 126px\" \/><\/a><\/td>\n<td style=\"width: 25%;\"><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Descending.png\"><img decoding=\"async\" class=\"size-full wp-image-243 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Descending.png\" alt=\"Image WPA Weight Descending\" width=\"124\" height=\"302\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Descending.png 124w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Descending-123x300.png 123w\" sizes=\"(max-width: 124px) 100vw, 124px\" \/><\/a><\/td>\n<td style=\"width: 25%;\"><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Ascending-Abs.png\"><img decoding=\"async\" class=\"size-full wp-image-245 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Ascending-Abs.png\" alt=\"Image WPA Weight Ascending Abs\" width=\"127\" height=\"302\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Ascending-Abs.png 127w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Ascending-Abs-126x300.png 126w\" sizes=\"(max-width: 127px) 100vw, 127px\" \/><\/a><\/td>\n<td style=\"width: 25%;\"><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Descending-Abs.png\"><img decoding=\"async\" class=\"size-full wp-image-246 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Weight-Descending-Abs.png\" alt=\"Image WPA Weight Descending Abs\" width=\"124\" height=\"301\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><\/h4>\n<h4>Format<\/h4>\n<p>Column formats can hep present data in easier-to-read ways by doing things like changing the number of decimals in a floating point number, the time unites of time-based data, and the base (hex? decimal? go crazy) of a integer data point.<\/p>\n<p>Supported Formats:<\/p>\n<table style=\"border-collapse: collapse; width: 100%; height: 94px;\">\n<tbody>\n<tr style=\"height: 44px;\">\n<td style=\"width: 50%; height: 10px;\">Time<\/td>\n<td style=\"width: 50%; height: 10px;\">Nanoseconds<\/p>\n<p>Microseconds<\/p>\n<p>Milliseconds<\/p>\n<p>Seconds<\/td>\n<\/tr>\n<tr style=\"height: 28px;\">\n<td style=\"width: 50%; height: 28px;\">Numeric<\/td>\n<td style=\"width: 50%; height: 28px;\">Decimal<\/p>\n<p>Hexadecimal<\/td>\n<\/tr>\n<tr style=\"height: 28px;\">\n<td style=\"width: 50%; height: 28px;\">Floating Point (%)<\/td>\n<td style=\"width: 50%; height: 28px;\">Decimal Places (group\/non group)<\/td>\n<\/tr>\n<tr style=\"height: 28px;\">\n<td style=\"width: 50%; height: 28px;\">Size (Bytes)<\/td>\n<td style=\"width: 50%; height: 28px;\">Bytes<\/p>\n<p>Kilobytes<\/p>\n<p>Megabytes<\/p>\n<p>Gigabytes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>As an example, open a trace captured with <em><a href=\"https:\/\/docs.microsoft.com\/en-us\/previous-versions\/windows\/it-pro\/windows-8.1-and-8\/hh448134(v=win.10)\">WPR&#8217;s General Profile<\/a> <\/em>and expand &#8216;Storage&#8217; and &#8220;double click&#8221; <em>Disk Usage<\/em> in the &#8216;<a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/test\/wpt\/introduction-to-the-wpa-user-interface#graph-explorer-window\">Graph Explorer<\/a>&#8216;.\nSwitch to the &#8216;Size by Process, Path Name, Stack&#8217; preset by clicking the drop down in the table&#8217;s title bar:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/disk-usage-preset-drop-down.png\"><img decoding=\"async\" class=\"size-full wp-image-228 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/disk-usage-preset-drop-down.png\" alt=\"Image disk usage preset drop down\" width=\"467\" height=\"383\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/disk-usage-preset-drop-down.png 467w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/11\/disk-usage-preset-drop-down-300x246.png 300w\" sizes=\"(max-width: 467px) 100vw, 467px\" \/><\/a><\/p>\n<p>The Size column is displayed as Bytes by default. By right clicking on the column header, the format can be configured:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Bytes-Size-Format-Config.png\"><img decoding=\"async\" class=\"size-full wp-image-247 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Bytes-Size-Format-Config.png\" alt=\"Image WPA Bytes Size Format Config\" width=\"431\" height=\"423\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Bytes-Size-Format-Config.png 431w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Bytes-Size-Format-Config-300x294.png 300w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>Conclusion<\/h3>\n<p>I hope this post give quick overview on how to configure columns to ease analysis in WPA. If you want to learn more, there are many more scenarios we did not cover that can be found at <a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/test\/wpt\/windows-performance-analyzer\">Microsoft Docs<\/a>.<\/p>\n<p>Keep a look out for Part 2 of this series where we dig into configuring the table columns for different graphing techniques!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the previous post, we discussed a brief intro into Windows Performance Analyzer (WPA) and its feature set.\u00a0 WPA can display trace data in a wide array of formats, most of which are pre-configured as presets designed for drilling into specific data points. Here is one for example: WPA&#8217;s CPU Usage (Sampled) table has a [&hellip;]<\/p>\n","protected":false},"author":40009,"featured_media":144,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,2],"tags":[14,8,13],"class_list":["post-221","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-performance-diagnostics","category-windows-performance-analyzer","tag-windows-performance-analyzer","tag-windows-performance-toolkit","tag-wpa"],"acf":[],"blog_post_summary":"<p>In the previous post, we discussed a brief intro into Windows Performance Analyzer (WPA) and its feature set.\u00a0 WPA can display trace data in a wide array of formats, most of which are pre-configured as presets designed for drilling into specific data points. Here is one for example: WPA&#8217;s CPU Usage (Sampled) table has a [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/posts\/221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/users\/40009"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/comments?post=221"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/posts\/221\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/media\/144"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/media?parent=221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/categories?post=221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/tags?post=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}