Meet other GoodData developers. Search our knowledge base. Attend live events.

GoodData

hi everyone, I have a MAQL-related question:

I have 2 Fact Tables `FactA` and `FactB` . Both of them have their own Date attribute `DateA` and `DateB` (to be more specific, one is on a daily granularity, the other one is one a monthly granularity).
Now I have an insight grouped by `DateB` (monthly), and I want to show a metric that is built on top of `FactA` under the condition that `DateA` (monthly) = `DateB` (monthly). I tried multiple combinations of `BY` and `WHERE`, but I cannot manage to make the metric appear. Any hints?

if necessary, I can try to build a more concrete example, but that would take a bit of time

Hi Thomas,

I am bit afraid it is caused by the way your logical model is being designed.

Could you share a print-screen of the model or the part where all related datasets are visible with me, please?

Or you can send me the ID of affected workspace and I can check the model on my own then.

You can use the DM for that.