MAQL check past date

Hi,

I noticed you already raised this question on our Slack so I will just recycle the answer provided by my colleague Zuzana:

depends how exactly the metric is going to be used and with what kind of context. But in general you can create metric like this:

SELECT IF (select count (Date (Ticket Created)) WHERE Date (Ticket Created)=THIS-3)=1 THEN 1 ELSE 0 END

Which takes Today date minus 3 days and then it is wrapped in IF condition to get also the other dates but these will be zeroes, only 3 days back is 1. This can be also changed to display YES or NO, e.g. by using metric formatting. e.g.

[=0]NO;[=1]YES;

Would that fit the use case?

Basically you can review our help articles on date arithmetic, using THIS syntax and conditional formatting.

https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/maql-analytical-query-language/maql-use-cases-and-tutorials/date-attribute-arithmetic

https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/maql-analytical-query-language/maql-use-cases-and-tutorials/finding-min-and-max-dates-using-date-arithmetic

etc.

I hope this helps.

Best,

Jakub