maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
avg_cycle_time_days is a formula measure (sum(cycle_time_sum)/nullif( sum(cycle_time_count),0)) over proposals that have a request→issued cycle time, so multi-bucket roll-ups stay correct. proposal_count is every proposal in the bucket.
Watch out for
- mediumIncluding proposals without a cycle time
cycle_time_count counts only proposals with a request→issued cycle time; the formula divides by it, not by proposal_count, so undated proposals don't bias the average toward zero.
- lowAveraging avg_cycle_time_days across buckets
It is a formula measure; do not average the per-bucket value client-side.
Questions this answers
- “What is the average proposal turnaround by study type?”
- “Does the escalated review path lengthen cycle time?”
7 of 7
Column
Type
Description
Tests · PII
issued_month
Date
First day of issued month. Grain + sort key.
1 test
entity
LowCardinality(String)
Issuing Smithers legal entity. Dimension + sort key.
1 test
study_type
LowCardinality(String)
Study type. Dimension + sort key.
1 test
review_path
LowCardinality(String)
standard / escalated. Dimension + sort key.
1 test
proposal_count
UInt64
Count of proposals in the bucket.
1 test
cycle_time_sum
Int64
Sum of cycle_time_days over proposals with a cycle time. Numerator of avg_cycle_time_days.
1 test
cycle_time_count
UInt64
Count of proposals with a non-null cycle time. Denominator of avg_cycle_time_days.
1 test