Skip to main content
Solved

Pull a dimension based on a number metric

  • March 27, 2024
  • 2 replies
  • 171 views
J
Apprentice Author
Forum|alt.badge.img+1

I everyone,

Do you know if there is a way to pull a dimension based on a metric ?
Here is what I would like to do :

I have a dimension that has :

  • An ID number column from 1 to 1000 (manually filled)
  • A Country dimension column (that I want to fill with a formula)
  • A Month dimension column (that I also want to fill with a formula)
  • An Activity dimension column (that I also want to fill with a formula)


On the other hand, I have a number metric with the tree dimensions Month, Country and Activity, with an input based on a formula that gives me numbers from 1 to 1000.

So in my dimension I would like to affiliate the month and the country regarding the column number, matching with the number metric. I tried Match and Item functions but it is not working.

Do you know if it is even possible with Pigment ? 

Thank you for your help ! 

 

Best answer by Nathan

you can do that using multi dimension.

Let’s assume the dimension you are showing is called ID, you can do that in Month of Signature

IF(ID.Name = Etape E, Month)[remove firstnonblank: Month,Zone, Level]

(Month, Zone Level, I’m not sure of the names, just remove all dimensions).

This basically creates a “cube” with all the dimensions of your metric + your ID dimension, finds the right match and “writes” the Month. 

Then you can “extract” it from these dimensions into your ID dimension by removing them, keeping just that one value you got.

 

Try it & tell me 

 

 

2 replies

Nathan
Employee
Forum|alt.badge.img+12
  • NathanEmployee
  • Employee
  • Answer
  • March 27, 2024

you can do that using multi dimension.

Let’s assume the dimension you are showing is called ID, you can do that in Month of Signature

IF(ID.Name = Etape E, Month)[remove firstnonblank: Month,Zone, Level]

(Month, Zone Level, I’m not sure of the names, just remove all dimensions).

This basically creates a “cube” with all the dimensions of your metric + your ID dimension, finds the right match and “writes” the Month. 

Then you can “extract” it from these dimensions into your ID dimension by removing them, keeping just that one value you got.

 

Try it & tell me 

 

 

KarlW
CDALMAY
J
J
Apprentice Author
Forum|alt.badge.img+1
  • Jacques d. S.Apprentice Author
  • Author
  • Apprentice Author
  • March 27, 2024

@Nathan It is working, thank you very much ! 

KarlW

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement