How to Create a Summary Table of Buildings by New York State REDC Region

Learn step-by-step how to create and format a summary table of buildings in New York State, grouped by REDC Region, including building count, total dwelling units, and median year built.

October 14, 2025 By Robin Neri

In this guide, we'll learn how to create a summary table of buildings across the different regions of New York State. We will group building data by region, calculate totals and medians, and format the results for clarity. This process will help you organize and present building information in a clear table that you can save or download.

Let's get started

In this guide, we will create a table summarizing buildings in various regions of New York State. Click on New, then select Question.

Go to metabase.c15.io

Step #2: Click "New" in the upper right — Click "New" in the upper right

Step #3: Click "Question" — Click "Question"

For this example we choose the table "All Attributes by Building" as our starting point.

In the question editor, select Group by New York State REDC Region.

The table will have building count, sum of gross floor area, and median Year Built.

Step #8: Select the summary statistics and columns — Select the summary statistics and columns

Sum of dwelling units is next.

Step #10: Click on "Sum of..." — Click on "Sum of..."

Median year built is next.

Select Visualize.

It may give a graph by default. Change this to a table by selecting "Visualization."

Click Done.

Format some of these numbers, such as median year built.

Click Column Formatting. For Separator Style, select one without commas to properly format the numbers as years.

Step #19: Click on "Median of Year Built" — Click on "Median of Year Built"

Change column names as desired.

Save this table by clicking "Save" in the upper right. Or, download this table by clicking "Download" in the lower right.