I’m trying to find a more efficient solution to modeling our yields. We have several dimensions by which we measure yields (region, segment, ramp status, etc...) and currently have separate blocks for each measure which can lead to confusion. I would like to consolidate yield calculations into a few blocks and pivot from there on the necessary dimensions. Any ideas on how to best set up yields?
it is very likely that it was done in separate blocks to simplify the “aggregation” with the right formula to parent levels of your dimension.
Without changing everything, make sure this block are in the same table. You’ll be able to easily switch between them