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

GoodData

Hey team, follow up question.
For a date dimension value, I need to build a query to check if the value is not set.
I can use logical condition for not equals with `&lt;&gt;` , however, how to check against `(empty value)` so the MQL metric query is `SELECT ... WHERE Date &lt;&gt; (empty value)` ?

Hi Māris,
For the start, could you please confirm whether you are using GoodData Cloud or GoodData Platform product?

image.png

If you are using GoodData Platform, what my colleague stated above should work.  In the metric editor, choose the corresponding date aggregation  and pick up `(empty value)` from list of attribute values. Example bellow:

Apologies, I misunderstood how to select the `(empty value)`

All is good - for the date dimension attribute, I could select `empty value` from attribute values for the date dimension.

Just to confirm - we are using GoodData Cloud.

In Cloud, you could use also something like this: `SELECT COUNT({label/order_id}) WHERE {label/date.day} NOT IN (NUll)`

Next time, I would also suggest you to write into the <#C04S1MSLEAW|gooddata-cloud> channel directly :slightly_smiling_face: Thanks!