Hey All, Got a date/time question related to an empty or null date field. We have a start and end datetime field in a dataset and when the end datetime field is null it means its on-going and therefore we would need to use "now" as the datetime to use instead of the one in the data column. Can we do something like that in a metric within gooddata?

Hi Steve, sorry for the delay in getting back to you here. But if you’re missing the end datetime timestamp from this particular field / column, it is not possible to add “now” as the datetime to use instead of the one in the data column. The only update you could perform here would be to update the data column by using Conditional Statements. Conditional statements that use IF THEN ELSE or CASE WHEN THEN formulations return values or metric expressions depending on whether specific conditions are met. More details on Conditional statements can be found here: https://www.gooddata.com/docs/cloud/create-metrics/maql/conditionals/

hmm, ok