Hey everyone, I hope you are all well. Does anyone have any general guidance for working with factless fact tables in GoodData? (Factless fact table is when the granularity of the table is an event or similar convergence of dimensions…..such as a booking event (registered, waitlisted, etc). I don’t have it in gooddata yet but will be trying to figure it out soon.

Hi Michael, would you please be so kind and provide more details on your use-case and more details on the general guidance you’re looking for in this case and I’ll be happy to help here! 🙂

It should be possible to add factless fact table into a data model. It may be good to create (composed) primary key definition in logical model if it exists but it is not mandatory. You may want to create metric using MAQL for counting of number of factless fact table rows with expresssion

SELECT COUNT({dataset/dataset_id})

. Such metric can be then used in different contexts, sliced and filtered by attributes etc.