Average flower time

This report will provide details on the Average flower time report. 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 flower time is a card report that pulls data from the plants table in METRC

Report intent

This report allows users to see the overall average flower time across all strains and flower rooms displayed as a number of days, with the ability to filter for specific flower rooms or strains.

Assumptions

This report relies on accurate plant data. If room moves and harvests are entered at incorrect dates, the times will not be accurate. 

Filters

Only plants that have been harvested, where "harvest date" is not NULL, are considered for creating average flowering time.

Calculations

Average flowering time is calculated by first taking only plants that have been harvested If a plant did not get harvested, it is not considered to for average flowering time.

For each plant that has been harvested, we calculate the number of days it spent in flower by calculating the difference in days between the "flowering date" and the "harvested date".

The report then takes an average of all the "flowering days" from all plants that qualify.