hi can we compare attribute with facts
# gd-beginnersg
Gaurav Tiwari
03/14/2023, 4:18 AMhi can we compare attribute with facts
i
Ivana Gasparekova
03/14/2023, 4:22 AMHi Gaurav,
I am afraid, this is not possible right now. What exactly should be a result of such comparison, please?
Could you provide me some example, please?
g
Gaurav Tiwari
03/14/2023, 4:37 AMi have two model one is course and another is assigned course in assigned course one facts with name of course id and i want to get assigned course data by using this
Gaurav Tiwari
03/14/2023, 4:38 AMin sql my query like [Yesterday 9:16 PM] Rameshwar Vyevhare
select COUNT(UCA.user_id) from user_course_assignments AS UCA INNER JOIN Courses AS C ON C.id = UCA.course_id
i
Ivana Gasparekova
03/14/2023, 4:47 AMI assume, that you are speaking about two datasets, rather than two models.
Firstly, I’d probably convert the “course ID” from the fact to the attribute, as it makes better sense for IDs in general.
g
Gaurav Tiwari
03/14/2023, 4:51 AMhow can we do this?
i
Ivana Gasparekova
03/14/2023, 4:52 AMYou can find some examples of COUNT syntax below:
https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/maql-analytical-q[…]guage/maql-expression-reference/aggregation-functions/count/
g
Gaurav Tiwari
03/14/2023, 5:00 AMi didn't get it will you please help me in query
Gaurav Tiwari
03/14/2023, 5:23 AMplease reply
j
Joseph Heun
03/14/2023, 7:18 AMHi Gaurav, as you are probably aware that MAQL statements depend on the logical data model in the workspace. You can connect datasets in MAQL with the BY caluse. There is an older article describing the use of explicit lifting for creating the connections, but the images are from the older product. However, the theory is the exact same. Moreover, there is an excellent free course on creating LDM’s and metrics in our GoodData University page which you may find very beneficial.
i
Ivana Gasparekova
03/14/2023, 12:48 PMAnd converting between facts and attributes can be found here;
https://help.gooddata.com/doc/enterprise/en/data-integration/data-modeling-in-gooddata/update-a-logical-data-model/#UpdateaLogical[…]tsandattributes
p
Productboard
04/21/2023, 8:02 AM🎉 New note created.