Skip to main content

Hello Pigment!


We have some scenarios where we use multiple Metrics with different dimensions on the same table, ex:
 


This table has Products and Month on Rows, Metrics as columns. Metrics structures below:

Metric Dimensions Formula
Product Demand Product, Month -
Vendor Product Products.Vendor
Planner Product Products.Planner


We are aware that a possible solution could be adding “Month” dimension on Vendor and Planner metrics then add “aADD CONSTANT: Month]” at the end of their formulas, this would lead us to our desired shape:
 



However, this might not be the ideal solution; we do not need to be “calculating” Vendor and Planner every Month, for every Product, since those are properties which are not changing at all (not monthly, weekly, at least). Our apps are quite big, that is why we are trying to avoid that.

There is a workaround? 
Also, there is a way to omit the “Total” rows/columns at all?

Hi @A_Garneri ,

In order to avoid having Vendor populated on all months you can add a filter to add the value only on the months where there is a Product demand:

Product.VendorrAdd CONSTANT: Month]]FILTER: ISDEFINED('Product demand')]

for the “Total” rows, you can remove it in the Aggregators menu:
 


Hope this helps,
Issam

Hello Issam!

Thanks for your comments,  sounds like a good approach to reduce amount of calculations.
If I understand well, we must add all dimensions (and calculate only on certain cells using filter) to be able to see data there, and there is not other way?  

Let's pretend my vendor doesn't come from one of my properties in the list and comes from an external calculation (which doesn't have the same dimension as the product demand metric). What if I have my metric Vendor where the source comes from Product Demand which in some scenarios can be blank as a result, therefore, my metric Vendor would be also blank. Next, I will use the Vendor metric for mapping an external metric, this will affect my result and not bring the info I need.

Reply


Ask your question here!

Terms & ConditionsCookie settings