Good afternoon
I'm trying to show the first issue date of a given document, filtering by branch.
Does anyone know if it's possible?
Best answer by Moises Morales
View originalGood afternoon
I'm trying to show the first issue date of a given document, filtering by branch.
Does anyone know if it's possible?
Best answer by Moises Morales
View originalHi, without looking at your data model it would be hard to say for sure how to achieve this exactly, but generally speaking, you would need a metric like this:Â
Â
SELECT MIN ((SELECT Date (Start Date) BY Event))
Please see the following article that covers this topic:
Finding Min and Max Dates Using Date Arithmetic - Gooddata Classic
Â
-Moises
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.