{"id":250,"date":"2021-06-28T17:07:58","date_gmt":"2021-06-29T00:07:58","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/?p=250"},"modified":"2021-06-28T17:07:58","modified_gmt":"2021-06-29T00:07:58","slug":"wpa-table-graph-configurations-part-2","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wpa-table-graph-configurations-part-2\/","title":{"rendered":"WPA: Table &#038; Graph Configurations (Part 2)"},"content":{"rendered":"<p>In <a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wpa-table-graph-configurations-part-1\/\">Part 1<\/a>, we discussed the different types of columns options available in WPA&#8217;s table views and how those views can be configured.<\/p>\n<p>This blog will continue the series by digging into how to configure columns for different graph styles that can show numeric aggregations, time, and hierarchical data:<\/p>\n<ul>\n<li>Column options (Aggregation\/Format\/Sort\/Text Alignment) \u2013 Part 1<\/li>\n<li><strong>How to configure columns for graphing (Line\/Bar\/Gantt) \u2013 Part 2<\/strong><\/li>\n<li class=\"\">Quick saving presets and Profiles \u2013 Part 3<\/li>\n<\/ul>\n<h4>Graphing Overview<\/h4>\n<p>Before we dive into how to configure the tables and graphs, we should do a quick introduction to the <span style=\"color: #ffcc00;\">Group<\/span> &amp; <span style=\"color: #3366ff;\">Graph<\/span> bars in WPA&#8217;s tables.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/09\/WPA-Table-Legend.png\"><img decoding=\"async\" class=\"size-full wp-image-116 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/09\/WPA-Table-Legend.png\" alt=\"Image WPA Table Legend\" width=\"506\" height=\"321\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/09\/WPA-Table-Legend.png 506w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/09\/WPA-Table-Legend-300x190.png 300w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/a><\/p>\n<p>Any column in the Data Area or Graphing Element Area can be aggregated (see <a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wpa-table-graph-configurations-part-1\/#aggregation\">Part 1 &#8211; Aggregation<\/a>). Aggregated columns are graphed when placed in the Graphing Element Area. Tables are pre-configured with presets on the recommended way to graph the data when analyzing at a high level, but can be modified based on user preference.<\/p>\n<p>There are two primary graphing modes:<\/p>\n<ul>\n<li>Plottable\/Numeric\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/test\/wpt\/graphs#line-stacked-line-and-stacked-bar-graphs\">Line<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/test\/wpt\/graphs#line-stacked-line-and-stacked-bar-graphs\">Stacked Line<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/test\/wpt\/graphs#line-stacked-line-and-stacked-bar-graphs\">Stacked Bar<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/test\/wpt\/graphs#flame-graphs\">Flame<\/a><\/li>\n<\/ul>\n<\/li>\n<li>Time Based (Gantt)\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/test\/wpt\/graphs#lifetime-graphs\">Lifetime<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/test\/wpt\/graphs#activity-type-graphs\">Activity<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Both graphing modes utilize the Group (Gold) Bar to pivot how the data can be displayed. The Legend to the left of the graph will help identify the data to the graph; the tooltip can also be used when hovering over the graph data.<\/p>\n<h4>Plottable\/Numeric<\/h4>\n<p>Plottable or Numeric graphs are useful for quickly analyzing the impact of different data sets over time. These numeric data columns are required with an aggregation to enable graphing. Each graphing column&#8217;s aggregation changes how the data is graphed in real time.<\/p>\n<p>As an example, open a ETL file captured with WPR&#8217;s GeneralProfile (First Level Triage) and open the Generic Events Table.\nBy default the table is configured to display as a Time Based graph; let&#8217;s change the graph to render event counts as a line graph:<\/p>\n<ul>\n<li>If not done already, Drag and Drop the Generic Events table into the Analysis View from the Graph Explorer<\/li>\n<li>Drag the &#8216;Time&#8217; Column to the left of the Graph (Blue) Bar<\/li>\n<li>Drag the &#8216;Count&#8217; Column to the right of the Graph (Blue) Bar<\/li>\n<\/ul>\n<p>WPA utilizes column metadata to understand how to configure time on the <strong>x-axis<\/strong>, these are configurable in the &#8216;Graph Configuration&#8217; tab in the &#8216;Advanced&#8217; dialog accessible via the &#8216;View Editor&#8217;:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2021\/06\/WPA-Advanced-Graph-Config.png\"><img decoding=\"async\" class=\" wp-image-354 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2021\/06\/WPA-Advanced-Graph-Config.png\" alt=\"Image WPA Advanced Graph Config\" width=\"473\" height=\"314\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2021\/06\/WPA-Advanced-Graph-Config.png 873w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2021\/06\/WPA-Advanced-Graph-Config-300x199.png 300w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2021\/06\/WPA-Advanced-Graph-Config-768x509.png 768w\" sizes=\"(max-width: 473px) 100vw, 473px\" \/><\/a><\/p>\n<p>Since the &#8216;Count&#8217; column is already configured to &#8216;Sum&#8217; aggregation by the default preset, in the below snapshot we can quickly see where event counts spiked across the timeline:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Event-Count.png\"><img decoding=\"async\" class=\"size-full wp-image-255 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Event-Count.png\" alt=\"Image WPA Generic Events Event Count\" width=\"1641\" height=\"592\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Event-Count.png 1641w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Event-Count-300x108.png 300w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Event-Count-1024x369.png 1024w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Event-Count-768x277.png 768w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Event-Count-1536x554.png 1536w\" sizes=\"(max-width: 1641px) 100vw, 1641px\" \/><\/a><\/p>\n<p>To change between the different graph modes, select the graph config drop down next to the magnify glass:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Plottable-Graph-Modes-1.png\"><img decoding=\"async\" class=\"size-full wp-image-257 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Plottable-Graph-Modes-1.png\" alt=\"Image WPA Plottable Graph Modes\" width=\"1028\" height=\"445\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Plottable-Graph-Modes-1.png 1028w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Plottable-Graph-Modes-1-300x130.png 300w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Plottable-Graph-Modes-1-1024x443.png 1024w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Plottable-Graph-Modes-1-768x332.png 768w\" sizes=\"(max-width: 1028px) 100vw, 1028px\" \/><\/a><\/p>\n<p>Line, Stacked Lines, &amp; Stacked Bars can be displayed with any aggregation type, where as Flame only supports the Sum aggregations only.<\/p>\n<h4>Time Based (Gantt)<\/h4>\n<p>Gantt charts are useful for looking at time based information, whether it&#8217;s point-in-time or time-range of data.<\/p>\n<p>A single time stamp column configured to the right of the blue bar will generate a point based graph, where each diamond (\u2666) represents a single point of time:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Point-Time.png\"><img decoding=\"async\" class=\"size-full wp-image-253 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Point-Time.png\" alt=\"Image WPA Generic Events Point Time\" width=\"1652\" height=\"651\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Point-Time.png 1652w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Point-Time-300x118.png 300w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Point-Time-1024x404.png 1024w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Point-Time-768x303.png 768w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Generic-Events-Point-Time-1536x605.png 1536w\" sizes=\"(max-width: 1652px) 100vw, 1652px\" \/><\/a><\/p>\n<p>A pair of time stamp columns (or a time stamp column + time delta column) to the right of the blue bar will generate a range based graph, where each bar represents a time range data:<a href=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Device-IO-Time-Range-Graph.png\"><img decoding=\"async\" class=\"size-full wp-image-254 aligncenter\" src=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Device-IO-Time-Range-Graph.png\" alt=\"Image WPA Device IO Time Range Graph\" width=\"1647\" height=\"637\" srcset=\"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Device-IO-Time-Range-Graph.png 1647w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Device-IO-Time-Range-Graph-300x116.png 300w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Device-IO-Time-Range-Graph-1024x396.png 1024w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Device-IO-Time-Range-Graph-768x297.png 768w, https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-content\/uploads\/sites\/64\/2020\/12\/WPA-Device-IO-Time-Range-Graph-1536x594.png 1536w\" sizes=\"(max-width: 1647px) 100vw, 1647px\" \/><\/a><\/p>\n<p><!--StartFragment --><\/p>\n<p><span class=\"cf0\">Depending on the analysis you are doing, it may make sense to switch between these two types of Gantt charts. Thankfully, WPA makes this very easy to do!<\/span><\/p>\n<p><span style=\"color: inherit; font-family: inherit; font-size: 1.75rem;\">Conclusion<\/span><\/p>\n<p class=\"\">I hope this post gives a quick overview on how to configure the table for graphing in WPA, there are many more scenario we did not cover that can be found at <a href=\"https:\/\/docs.microsoft.com\/en-us\/windows-hardware\/test\/wpt\/windows-performance-analyzer\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Docs<\/a>.<\/p>\n<p>Keep a look out for Part 3 of the series where we dig into how to take these configuration into presets and profiles!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Part 1, we discussed the different types of columns options available in WPA&#8217;s table views and how those views can be configured. This blog will continue the series by digging into how to configure columns for different graph styles that can show numeric aggregations, time, and hierarchical data: Column options (Aggregation\/Format\/Sort\/Text Alignment) \u2013 Part [&hellip;]<\/p>\n","protected":false},"author":40009,"featured_media":76,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,2],"tags":[14,8,13,9],"class_list":["post-250","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","tag-wpt"],"acf":[],"blog_post_summary":"<p>In Part 1, we discussed the different types of columns options available in WPA&#8217;s table views and how those views can be configured. This blog will continue the series by digging into how to configure columns for different graph styles that can show numeric aggregations, time, and hierarchical data: Column options (Aggregation\/Format\/Sort\/Text Alignment) \u2013 Part [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/posts\/250","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=250"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/posts\/250\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/media\/76"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/media?parent=250"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/categories?post=250"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/performance-diagnostics\/wp-json\/wp\/v2\/tags?post=250"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}