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.
Best answer by Julius KosView original
No problem, glad to help!
If you are more interested in learning about MAQL - I can strongly recommend you our University MAQL course:
Thanks Julius, your’e right, it works now (i should have invested a bit more time exploring moql syntax)
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!
Done, thank you in advance!
Please feel free to invite us with admin rights. Might be handy for future.
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 email@example.com into the particular Workspace?