Skip to main content
Solved

Best way to calculate yield?

  • March 31, 2023
  • 1 reply
  • 296 views

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

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

1 reply

Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • Answer
  • April 4, 2023

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