Join Slack
Powered by
Hello All I want to create the custom matrics to f...
# gooddata-platform
g
GauravP
02/10/2022, 7:23 AM
Hello All I want to create the custom matrics to filter the records based on type and data. For e.g.
SELECT COUNT(id) WHERE start_date = Nil
How can I write the query to check the data is Null or Nil using GoodData MAQL?
m
Michael Ullock
02/10/2022, 8:48 AM
Hello, your metric in this case would look something like this:
Select COUNT (ID) WHERE Date (start_date) = (empty value)
Heres some additional resources that you may also find useful:
https://community.gooddata.com/metrics-and-maql-kb-articles-43/how-to-use-maql-count-in-gooddata-platform-301
https://help.gooddata.com/pages/viewpage.action?pageId=86794934
p
Productboard
02/10/2022, 10:56 AM
🎉
New note created.
Open in Slack
Previous
Next