Solved

Chaining dimension properties across dimensions

  • 28 February 2023
  • 1 reply
  • 73 views

Userlevel 3
Badge +5

Hey everyone,

 

I have a transaction list of revenue by month by User ID.

 

My User ID dimension has the property “Employer”.

 

My Employer dimension has the property “Parent Company”.

 

I want to create a metric with dimensions Months and Parent Company to sum the revenue from my transaction list.

 

How do I chain the dimension properties in the by sum statement? I need to go from User ID > Employer > Parent Company across multiple dimension lists.

 

Thanks!

 

 

icon

Best answer by Trever Leavenworth 28 February 2023, 20:31

View original

1 reply

Userlevel 3
Badge +5

I figured it out! Posting in case anyone else has the same question.

 

I was chaining them in reverse, trying to start with the most aggregated (Parent Company) and come down to the User ID in my transaction list. They need to go the opposite direction.

 

So the statement is:

[by sum: 'IMPORT - Revenue by User ID'.trx_month, 'Import - Revenue by User ID'.user_id.users_employer_id.ParentCo]

 

Reply