Skip to main content

Hello Pigment Community,

I have an interesting question regarding dynamic metric dimensions.

Is it possible to modify the dimensions of a metric dynamically based on user input? I understand that we can input values (e.g., Revenue, Cost, etc.) at different hierarchy levels using dependent dropdowns. However, after entering these values, I want all associated calculation metrics to automatically adjust to the selected dimensions.

For example:

  • I input data at L2: Country (with parent L1: Region) and L2: Industry (with parent L1: Industry Type and child L3: Sub-Industry).
  • Using dependent dropdowns, users can enter values at the correct hierarchy.
  • I want all relevant calculation metrics to dynamically align with L2: Country and L2: Industry based on the selected input.

Can this be achieved in Pigment? If not, what would be the best way to request this functionality?

Looking forward to your guidance. Thanks!

Hi ​@Spandan98 

Currently, we cannot dynamically modify the dimensions of a metric based on user input. Once the dimensions of a metric are set, they remain static and cannot be adjusted dynamically. This is because the structure of a metric, including its dimensions, is fundamental to its definition and how it operates within the model, also, could lead to errors/inconsistencies. 

As a workaround, you can create different metrics for each dimension combination and then use these metrics in your calculations. 

If you believe this feature would be beneficial, feel free to check out the Ideas section for new product feature suggestions: https://community.pigment.com/ideas

For more information on Item Variables, Block settings for Metrics, Data input options for Metrics, Dynamic Variable Metrics, refer to our articles here:

 

Reply


Ask your question here!

Terms & ConditionsCookie settings