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.
Best answer by Nathan
View original
Userlevel 6
+7
- Employee
- 130 replies
-
21 November 2022
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 5
+6
- Employee
- 95 replies
-
21 November 2022
- Answer
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]
- New Pigmenteer
- 1 reply
-
21 November 2022
Thanks! I was able to reference the needed data by changing the list type within metrics.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.