Average THC by flower location by month

This report will provide details on the Average THC by flower location by month. It will detail the report's intent, assumptions used, filters applied to the underlying data, and any calculations used.

TABLE OF CONTENTS

• Report Definition
• Report intent
• Assumptions
• Filters
• Calculations

Report Definition

Average THC by flower location by month is a multi-line report pulling data from METRC test results and harvest batches.

Report intent

This report allows users to see the average THC of all test results from all harvests from each flower room, by month. 

Assumptions

This report assumes:

• The "location" of plants in METRC when harvested is the room they spent most of their time flowering
• THC test results are only considered for METRC product categories of "buds" and "shake/trim", no other product types are considered
• Only "Total THC (%) Raw plant material" is considered for raw plant material test results

Filters

All test results are considered, but no harvest batches are considered if they have no test results. 

Calculations

Average THC is calculated by taking every unique instance of the Total THC % Raw plant material test and taking its average. Flower location is taking the location the plants were harvested from.