Solved

Working with metrics

  • 6 September 2022
  • 7 replies
  • 51 views

  • Known Participant
  • 13 replies

Hello,

I have a question regarding the working with metrics topic. 

I have read through documentation related to this topic but it's still unclear to me why Attributes become unavailable when I pick a metric that I created. 
I'm trying the basic concept of creating a metric by summing up 2 facts from different fact tables of the data model. Both tables are related to one dimension table (that stores all attributes) as 1:N.

The interesting part for me is that if I'm using these same 2 facts separately, most of the attributes remain available.  

Please see the screenshots below.

 

icon

Best answer by Julius Kos 7 September 2022, 15:10

View original

7 replies

Userlevel 2

Hello Masha, 

 

This depends on the way how is your Logical Data Model (LDM) built. Should we check this further, we would need to see your LDM. Can you please invite our support user support+aklamio@gooddata.com into the particular Workspace? 

 

Thank you

@Julius Kos Hi Julius, thanks for the fast reply. As per roles description, to grant data model visibility I should invite  support+aklamio@gooddata.com as Editor, is that correct? 

Userlevel 2

Please feel free to invite us with admin rights. Might be handy for future.

 

Thanks! 

Done, thank you in advance!

Userlevel 2

Hello Masha,

 

Thank you for the invitation! 

 

The issue actually isn’t related to your LDM. The problem is in the syntax of your metric which you are using:

 

You must either aggregate the both attributes so the correct syntax would be:

 

Or alternatively, you can create the SUMs as separated metrics and sum them as bellow:

 

I hope this helps! 

Thanks Julius, your’e right, it works now (i should have invested a bit more time exploring moql syntax)

Userlevel 2

No problem, glad to help! 

 

If you are more interested in learning about MAQL - I can strongly recommend you our University MAQL course:

https://university.gooddata.com/getting-started-with-maql

 

Best regards

Reply