Customizing Dynamic Text in Layout
I have a layout that displays a set of traffic accidents at a given intersection and must dynamically update the Primary Street, Secondary Street, From Date, To Date, and counts of injury severity based on the visible points in the map frame.
I have three specific questions:
1) For Primary Street and Secondary Street, how do I display ONLY the attributes for the first row in my table? I am currently getting a list of all distinct Primary and Secondary Streets visible in the map frame.
2) For From Date, how do I display just the oldest date? For To Date, how do I display just the most recent date? Again, I am currently getting a list of all distinct dates visible in the map frame.
3) For injury counts, how can I count different values from the same attribute field? It appears I am not able to use iif() because it is only evaluating one row at a time, instead of treating all the points visible in the map frame as a table to be parsed.
The purpose of this layout is to create a custom print template in Experience Builder. If there is a better way to go about this task as a whole, please let me know that too!
I forgot to clarify, adding a SQL query is separate from the expression builder option. To access it change the Query type from all or visible to Custom query. That exposes the SQL query builder.
