How we apply condition in MAQL for finish date <...
# gd-beginnersg
Gaurav Tiwari
04/13/2023, 1:36 PMHow we apply condition in MAQL for finish date < now date
j
Jan Soubusta
04/13/2023, 1:42 PMj
Joseph Heun
04/13/2023, 1:51 PMg
Gaurav Tiwari
04/13/2023, 3:04 PMbut i am getting
i
Ivana Gasparekova
04/13/2023, 3:08 PMThis looks like you are working with GD Platform and the article from Jan is for Cloud Native.
Have you tried to search for some keywords within our documentation, please? Do you have troubles to find relevant information this way?
This article should help:
https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/maql-analytical-q[…]e-where-clause/referencing-floating-time-periods/this-macro/
g
Gaurav Tiwari
04/13/2023, 5:05 PMi used this query but i get wrong o/p will you please suggest me what's wrong in this
j
Jakub Kopecky
04/14/2023, 7:56 AMwell 2 things…
Jakub Kopecky
04/14/2023, 7:57 AM1) I am not sure why you use Day of Month - that will give you something like D14 - 7120, I would suggest to use a normal Date (End Date)
Jakub Kopecky
04/14/2023, 7:57 AM2)rewrite your range with BETWEEN THIS - 7120 AND THIS -1
Jakub Kopecky
04/14/2023, 8:03 AMmaybe a third one… 7120 days is something above 19 years… is that really the range you wanted?