Is anyone available to support the creation of a m...
# gooddata-cloudm
Max Donsky
12/12/2024, 9:40 PMIs anyone available to support the creation of a metric? Just trying to understand what the equivalent in MAQL would be for a "NOT EXISTS" function in a sql query
m
Moises Morales
12/12/2024, 10:10 PMHi Max, in MAQL, you would need to use filters or conditional aggregation to achieve something similar to "NOT EXISTS". I would recommend checking the expressions here depending on what the metric should display: https://www.gooddata.com/docs/cloud/create-metrics/maql/filters/
Moises Morales
12/13/2024, 5:08 PMAllow me to send over here the response sent privately for reference purposes:
I believe the easiest way would be to apply a filter directly to the insight for the attribute Judicial Review Application so the insight displays the values that do not have one, typically as a NULL value or " ". Note that if the null values are not in the workspace, then it won't be possible for the platform to interpret them as NULL.
Additionally, you can create an SQL dataset where you can apply the query directly. It's the same idea as here: https://gooddataconnect.slack.com/archives/C01P7PBJFLH/p1733955517954199?thread_ts=1733954466.257939&cid=C01P7PBJFLH
4 Views