Josh Collins
08/31/2021, 8:07 PMMoises Morales
09/01/2021, 7:35 AMSELECT 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
You can find further information about this in our documentation. You will need to make sure you are using the relevant connection point (attribute) and follow the exact metric syntax as above. Feel free to let us know how you get on.Josh Collins
09/01/2021, 1:30 PM