# Analysis

Use Analysis to chart share of products, facings, linear space, quadratic space or sales by tag, and download the results as Excel or a chart image.

***

## Analysis tab

- Select **Analysis** under Studio in the navigation panel to find data from the planogram.

- This is done by adding KPI and tags that you are interested in. The tags will be from the input file and can include brand, category, subcategory and segmentation.

- It can calculate share of products, facings, linear space and quadratic space for the planogram, and sales if the input file has a `tags.sales` column (see [Tags and segmentation](/studio/tags-and-segmentation)). Quadratic space uses each product’s width and height, not its depth.

- Choose what the analysis shows:

Choose the **scenario fixture**, or **All Fixtures** to analyse every fixture in the project together. All Fixtures adds up the facings, space and sales of every fixture, and counts a product on several fixtures once in Share of SKUs.

Choose a **bay**, or **All Bays**, to analyse one bay of the fixture. Then choose a **shelf** in that bay, or **All Shelves**. You can choose a shelf only once you have chosen a bay. Bay and Shelf are only available when you choose a single fixture, not All Fixtures. Choosing another fixture sets Bay and Shelf back to All Bays and All Shelves.

Choose the **metrics** that you want to be shown on the graphs

Choose the **brand/subgroup** that you would like to compare data.

Choose whether you would like the graph to show **numbers** or **percentages**.

- Each is a drop down menu. The metrics are **Share of Facings**, **Share of SKUs**, **Share of Linear Space**, **Share of Quadratic Space** and **Sales**.

* Select **Download**, then **Excel**, to download an Excel file with all of the analysed data. The Excel file always covers whole fixtures, whichever bay or shelf you chose.

* Analysis shows this information as a graph too. Select **Download**, then **Image**, and the chart on screen will download as a PNG image. Its title names the bay and shelf you chose.

* Once all parameters have been chosen, the graph shows a group of bars for each value of the tag, for example each product subgroup, with one bar for each metric you chose.

* The side panel’s **Detail** for a fixture, bay or shelf also shows its analysis. Select **Charts** beside its Analysis heading to open Analysis on that fixture, bay or shelf.