Solved

Show first date, filtering by branch

  • 31 October 2022
  • 1 reply
  • 21 views

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?

icon

Best answer by Moises Morales 31 October 2022, 21:53

View original

1 reply

Userlevel 3

Hi, 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

Reply