Skip to main content

Hi Pigment Community,

 

Hope you’re all doing well. I’m currently having a formatting/metric structure issue and was wondering if anyone had a solution to my problem.

 

The current challenge I’m facing is that when I create a table using 2 existing metrics and 1 input metric, the format of my table follows the input metric, when I would like it to follow the format of the existing metrics. To further explain I have a list of managers and territories. Managers only operate in one territory, so in a table manager A should only be seen under country X, however I am seeing that Manager A is listed under Country A, B, C, etc...

Blocks:

  • DIMENSION: Opp Owner Name
  • METRIC: Revenue C$] Y-1
  • METRIC: Revenue C$] Y-2 (no picture provided because its the same as Revenue a$] Y-1)
  • METRIC: Yearly Bookings y$] - Input - NBiz
  • TABLE: Output Yearly Bookings ($)


To help explain I have attached images below that walk you through the issue I am facing.

The first image “Opp Owner Name” shows a dimension that has a mapping between managers and territories. This mapping is used to have managers displayed under the correct countries. 

“Opp Owner Name” - Metric Y-1 & Y-2 use “Manager level 3” & “Territory level 3” which provides the structure to them

This metric, “Revenue r$] Y-1”, shows the total revenue from the previous year. It will be used as a gauge for the user to determine what the input should be. Note that here each manager is under the correct country and the manager is not repeating under each country.
 

Metric Y-1: Revenue for the previous year. NOTE: The information under each country is properly organized because it is coming from the “Opp Owner Name” dimension

This metric, “Yearly Bookings u$] - input - NBiz”, is a blank metric that the user will input revenue projections into. Inputted values will be used for calculations in the future. Here you can see that the metric shows every single manager under the country australia, this problems repeats for every 

Input Metric - notice that the names are not properly allocated. Every name shows up for every country

The table below, “Output Yearly Bookings ($)”, brings the 3 metrics together. under the third column the user will input their reveune. However, you can see that the table is following the format of the Input metric and not the Y-1 metric.

This table combines all thre metrics. NOTE that the table has the structure of the “Input” metric and not the structure of the Y-1 or Y-2 metrics

Thank you for the help!

Darious

Hi @darious ,

Have you tried to adjust the filter option to Hide the empty rows?
Here is an example: 

  • Input table shows all possible input cells with the filter option on “Show empty rows and columns”:
  • Table with filter option “Hide empty rows” to filter out unnecessary rows where the calculated metric is empty:

Hope this helps,
Issam

Hi Issam, 

That worked perfectly as always. Can’t believe I didn’t think of that before posting! 😅

Thank you for the help! 😄

Reply


Ask your question here!

Terms & ConditionsCookie settings