Solved

Referencing objects

  • 21 November 2022
  • 3 replies
  • 408 views

Badge

Hello Team,

Is there a way to reference an object(from a transaction list) within a metric without having it auto aggregate? See screenshots for reference.

 

 

icon

Best answer by Nathan 21 November 2022, 18:05

View original

3 replies

Userlevel 6
Badge +14

Hi Dominick,

Pigment is trying to align dimensions without having the relevant explicit relationship.

Have you tried using the Formula Playground? If you set it as Automatic Structure, you may use what you’ve already typed 'Fund data'.Commitment and add the relevant BY until you get to the right structure, like 'Fund data'.Commitment[BY: 'Fund data'.Vehicle]

Please note that you won’t be able to aggregate values based on that Investor property because it’s only a text-format property, not dimension-format.

Hope this helps!

Userlevel 6
Badge +11

Hello Team,

Is there a way to reference an object(from a transaction list) within a metric without having it auto aggregate? See screenshots for reference.

 

 

A Transaction list cannot be used as a dimension of a metric, which is what you are doing. So in your case no: Pigment will have to aggregate before displaying it to you.
However you can run any operations at the transaction list level before aggregating it with a BY.

Like 'Fund data'.Commitment[filter:’Fund data’.’Other Expenses’>0][BY: 'Fund data'.Vehicle]

Badge

Thanks! I was able to reference the needed data by changing the list type within metrics.

Reply