Solved

Can not get max of date at the higher level

  • 23 March 2022
  • 1 reply
  • 152 views

  • Known Participant
  • 11 replies

Hi there,

I'm facing a big problem that I’m not able to get the maximum of date group by at rows, my insight will break down by that date level.

I want to get the most recent listing date of “Subdivision Name” and “Region Name”, example at Subdivision is ‘Crane Landing’ has “Most Recent Listing Date” = ‘02/21/2022’.  Any ways to do this?

Thanks for your help!

icon

Best answer by Julius Kos 23 March 2022, 12:19

View original

1 reply

Userlevel 2

Hi Lena, 

 

You can use a date arithmetic with date attributes to achieve this. If you wish to display the MAX date of some event, please follow our documentation here:

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

 

Best Regards,

Julius

Reply