{"id":179663,"date":"2015-10-13T09:00:47","date_gmt":"2015-10-13T16:00:47","guid":{"rendered":"http:\/\/www.microsoft.com\/?p=179663"},"modified":"2024-08-30T13:41:19","modified_gmt":"2024-08-30T20:41:19","slug":"time-grouping-enhancements-in-excel-2016","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/","title":{"rendered":"Time grouping enhancements in Excel 2016"},"content":{"rendered":"

Excel 2016 introduces new features and improvements that help you streamline your data analysis. Today we will walk through the new options for building PivotTables with a Date\/Time column and show how to surface time-based insights in your data. Additionally, we will help you take advantage of the ability to navigate your PivotCharts using drill-down buttons.<\/p>\n

Automatic time grouping<\/h3>\n

Automatic time grouping, a new feature in Excel 2016, helps use time-related fields in a PivotTable by auto-detecting and grouping them on your behalf. The automatic grouping creates new Date\/Time columns and automatically populates the PivotTable in one action. This allows users to quickly start analyzing their data across different levels of time with drill-down capabilities.<\/p>\n

PivotTable grouping is used frequently by customers in many business scenarios. Implementing grouping for Data Model PivotTables allows for grouping to be used in conjunction with the power of the xVelocity engine and is a key feature for making Data Model PivotTables a replacement for native ones in the future. When used in a data model PivotTable, Time grouping adds relevant Date\/Time columns such as Date (Year), Date (Quarter) and Date (Month) to the grouped table in the model; these columns could then be reused with other user endpoints of the data model, such as PowerView and Power BI.<\/p>\n

\"Time<\/p>\n

Time grouping columns in the model.<\/em><\/p>\n

The Date\/Time columns are automatically added according to the Data column date\/time granularity. For example, if the date data is in days and is for more than a year\u2019s duration, then the added grouping columns would be for months, quarters and years.<\/p>\n

Once the Date\/Time columns are added to the model, not only can you analyze your data over the different time granularities it entitles, but you may also find additional insights. For example, to get a monthly year-over-year comparison of your data, drag the Date (Year) column over from the ROWS drop zone to the COLUMNS drop zone while keeping only the Date (Months) column in the ROWS drop zone.<\/p>\n

Auto-grouping for a data model PivotTable also means that for the first time in Excel you are able to aggregate data larger than one million rows.<\/p>\n

\"\"<\/p>\n

Right-click Group and Group dialog.<\/em><\/p>\n

Changing the Group columns is always possible through the usual user interface. In the PivotTable, right-click the Date<\/strong> column and select Group<\/strong>.<\/p>\n

The Group dialog is where you can define other columns to be added or removed from the time group. You may have noticed that \u201cStarting at\/Ending at\u201d and \u201cNumber of days\u201d are greyed out; this is because we do not support these settings for data model PivotTables.<\/p>\n

Don\u2019t like automatic grouping? Undo it just like you would any other applied change. The first undo (Ctrl+Z) removes the auto-added columns from the ROWS drop zone. The second undo removes the newly added columns from the model, so you are back at square one. In case these columns are already used in another PivotTable, then they will not be deleted from the model. Right-click Ungroup\u2026<\/strong> is also supported and will act as if you have done the two undo operations, removing the group fields from the drop zones and the model. You can also turn off automatic time grouping.<\/p>\n

When the model already contains a \u201cDate Table,\u201d we do not want to do time grouping, since the \u201cDate Table\u201d includes all required date columns already. So when building a PivotTable and dragging a Date column from a \u201cDate Table\u201d from the data model, automatic grouping would not apply.<\/p>\n

PivotChart drill-down buttons<\/h3>\n

PivotCharts have always supported a double-click on a chart element to do a drill-down to the next level of the selected element. This is the same as clicking the plus sign on the PivotTable collapsed level. A tougher job is when you want to expand all objects in the PivotTable to the next level. This is where the newly added PivotChart drill-down buttons come in handy, as clicking the + <\/strong>(plus) or \u2013<\/strong>\u00a0(minus) buttons allow you to drill down to the next level of all elements in the charts with a single click.<\/p>\n

This functionality applies to any hierarchy or any set of columns in the ROWS drop zone of the PivotChart.<\/p>\n

When you open a PivotTable created on a previous version of Excel, you will not see the new drill-down buttons until you enable them on the Analyze ribbon. It is also possible to remove these buttons from a chart created in Excel 2016.<\/p>\n

\"\"<\/p>\n

Toggle viewing of PivotChart field buttons.<\/em><\/p>\n

Reuse of time group fields in Power BI<\/h3>\n

The new Date columns really come in handy in Power BI. One noticeable value to users is that the Month column added to the data model through the Automatic Grouping in Excel is calendar ordered (Jan, Feb, Mar\u2026).<\/p>\n

\"Power<\/p>\n

The new Date columns put to use in PowerBI.com.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Excel 2016 introduces new and efficient capabilities. PivotTables, both native and data model based, now support automatic time grouping, and PivotCharts include drill-down buttons. Today we will walk through all the new and cool options for building PivotTables with a Date\/Time column and show how to surface time-based insights in your data.<\/p>\n","protected":false},"author":3368823,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4034,4035],"product":[4047,4036,4062],"audience":[4081,4101,4102],"tags":[],"coauthors":[4437],"class_list":["post-179663","post","type-post","status-publish","format-standard","hentry","content-type-news","content-type-tips-and-guides","product-excel","product-microsoft-365","product-power-bi","audience-enterprise","audience-personal-and-family","audience-small-business","review-flag-1680288349-139","review-flag-1680288349-585","review-flag-alway-1680288348-694","review-flag-new-1680288347-871"],"yoast_head":"\nTime grouping enhancements in Excel 2016 | Microsoft 365 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Time grouping enhancements in Excel 2016 | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"Excel 2016 introduces new and efficient capabilities. PivotTables, both native and data model based, now support automatic time grouping, and PivotCharts include drill-down buttons. Today we will walk through all the new and cool options for building PivotTables with a Date\/Time column and show how to surface time-based insights in your data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-13T16:00:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-30T20:41:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/10\/Time-grouping-enhancements-in-Excel-2016-1-words-1024x858.png\" \/>\n<meta name=\"author\" content=\"The Microsoft 365 Marketing Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Microsoft 365 Marketing Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/\",\"@type\":\"Person\",\"@name\":\"The Microsoft 365 Marketing Team\"}],\"headline\":\"Time grouping enhancements in Excel 2016\",\"datePublished\":\"2015-10-13T16:00:47+00:00\",\"dateModified\":\"2024-08-30T20:41:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/\"},\"wordCount\":811,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/10\/Time-grouping-enhancements-in-Excel-2016-1-words-1024x858.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/\",\"name\":\"Time grouping enhancements in Excel 2016 | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/10\/Time-grouping-enhancements-in-Excel-2016-1-words-1024x858.png\",\"datePublished\":\"2015-10-13T16:00:47+00:00\",\"dateModified\":\"2024-08-30T20:41:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/10\/Time-grouping-enhancements-in-Excel-2016-1-words-1024x858.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/10\/Time-grouping-enhancements-in-Excel-2016-1-words-1024x858.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Time grouping enhancements in Excel 2016\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Time grouping enhancements in Excel 2016 | Microsoft 365 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/","og_locale":"en_US","og_type":"article","og_title":"Time grouping enhancements in Excel 2016 | Microsoft 365 Blog","og_description":"Excel 2016 introduces new and efficient capabilities. PivotTables, both native and data model based, now support automatic time grouping, and PivotCharts include drill-down buttons. Today we will walk through all the new and cool options for building PivotTables with a Date\/Time column and show how to surface time-based insights in your data.","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2015-10-13T16:00:47+00:00","article_modified_time":"2024-08-30T20:41:19+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/10\/Time-grouping-enhancements-in-Excel-2016-1-words-1024x858.png"}],"author":"The Microsoft 365 Marketing Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Microsoft 365 Marketing Team","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/","@type":"Person","@name":"The Microsoft 365 Marketing Team"}],"headline":"Time grouping enhancements in Excel 2016","datePublished":"2015-10-13T16:00:47+00:00","dateModified":"2024-08-30T20:41:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/"},"wordCount":811,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/10\/Time-grouping-enhancements-in-Excel-2016-1-words-1024x858.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/","name":"Time grouping enhancements in Excel 2016 | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/10\/Time-grouping-enhancements-in-Excel-2016-1-words-1024x858.png","datePublished":"2015-10-13T16:00:47+00:00","dateModified":"2024-08-30T20:41:19+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/10\/Time-grouping-enhancements-in-Excel-2016-1-words-1024x858.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/10\/Time-grouping-enhancements-in-Excel-2016-1-words-1024x858.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/10\/13\/time-grouping-enhancements-in-excel-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Time grouping enhancements in Excel 2016"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/179663"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/3368823"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=179663"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/179663\/revisions"}],"predecessor-version":[{"id":274441,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/179663\/revisions\/274441"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=179663"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=179663"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=179663"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=179663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=179663"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=179663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}