Hi! I’m transitioning the Revenue Model to Causal. This means that (a) each team within Commercial will “own” their projections, (b) there will be more than one way of modelling volume
Example: Team A will own the volume projection for Groceries, and they will model volume as # stores x avg volume per store. Team B, however, will own the volume projection for Food and they will model volume based as a % increase YoY.
Goal is to have a single variable (let’s call it Monthly Volume), categorised by team.
What do you think is the best way of doing this? I see two alternatives:
a) A single model with views for each team. Problem is, in practice I would need multiple variables and an ugly Volume variable with lots of IFs. Sounds error-prone
b) Multiple models, one for each team. This is very clear and less error-prone, but I don’t think I can link the models to have a variable categorised by team