hey guys, i have a fact table that records transactions anyone know how i can get the last transaction date for each id? I tried the following SELECT MAX(DATE) BY CUSTOMER_ID

Hi Felipe, the metric would look something like the following:

SELECT MAX ((SELECT (10000 * MAX(Year (Date))) + (100 * MAX(Month (Date))) + (MAX(Day of Month (Date))) BY <connection point>)) 
WHERE (SELECT COUNT(Date (Date), <connection point>) BY Year (Date), ALL OTHER) > 0

Then you would need to use custom number formatting to display the date as such:

[=null]N/A; ########