Best way to calculate yield?

  • 31 March 2023
  • 1 reply

Userlevel 1

Hi Everyone,


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?


Best answer by Nathan 4 April 2023, 14:03

View original

1 reply

Userlevel 6
Badge +12

Hi Nicole,


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