Hi,
from the version 7.4, the user needs to explicitly define the aggregation for the map: that is needed to support the Spatial Attribute defined as CLOB in the DB; the LOB datatypes cannot be used in the GROUP BY clause of SQL.
That said, as you can see you from your screenshot, you are not aggregating by any attributes. If you doesn't select the attribute for aggregation Knowage will not extract that field from the query and will not insert it in the GROUP BY clause.
My suggestion is: if you don't use CLOB for the spatial attribute, aggregate for all the attributes. In that case you should use dateObserved for the detail popup.