-----------------
Hi,
I'm using the GrowthBook experiment platform with a fact table–based data source (BigQuery). When I define N metrics on top of the fact table, GrowthBook is able to compute all metrics with a single underlying query, which is very efficient.
However, when I view Experiment → Results and apply a segment, GrowthBook stops using the single fact-table query and instead executes *N separate queries*—one for each metric. This makes the query execution significantly less efficient and increases BigQuery cost.
Is this expected behavior? And is there any way to preserve the single-query optimization when segmentation is applied?