Skip to main content

Hello!

 

I’m attempting to aggregate my metrics into a full P&L with actual and forecast views.

 

I have data coming from a Shared_IS_Actuals dimension, several Revenue and COGS dimensions already mapped, a Shared_WF_Plan dimension, and a Shared_Opex_Plan dimension.

 

I’ve been able thus far to successfully have Actuals for all IS accounts pull in, and have Revenue, COGS, and WF (payroll, benefits, taxes) appear in a single metric.

 

However, when I try to add my Shared_Opex_Plan data using the formula below, my Actuals stay, my revenue and cogs disappear, my WF_Plan stays, and my Opex_Plan disappears, leaving me with only the WF_Plan.

 

 

It’s like the first by modifier to map the WF_Plan to the CoA is applying to everything?

 

What am I missing? 

 

Hey Trevor,

 

firstly, you do not need the ( ) around your Metriccmodifier], they apply in priority to the metric they are right after.

I can’t tell from the formula but it is VERY likely that the 4 parts (the 4 metrics) of the formula do not have the same dimensionality, Pigment doesn’t manage to align manually and you end up with a weird result.


I 100% agree with Nathan, it looks like your Opex and WF metrics do not share the same dimensions.

Here’s a great article that explains what happens when you add two metrics with different dimensions together :

 

Try to align both metrics using REMOVE, ADD or BY depending on your use case to try and have the result you expect.


Reply