Distinct Dynamic text from attribute?

Question

Is there a way to only get the unique values from a field in a feature class?

I have multiple AVL records and would like to use dynamic text to populate which vehicles are being displayed on the map in the layout view.

I've tried using a distinct SQL query within dynamic text and it keeps telling me my query is invalid. I've also explored Table Frames a bit but there doesn't seem to be a way to filter it down.

Thanks

Anonymous User · Answer

Thank you for your reply robert, but I think it's still not quite what I'm looking for. I would need to do a map series based on vehicles in order for that to work, correct?

I am ok with multiple vehicles on the map at any one time but I only want to know which vehicles are there during the time frame I specified. I dont think what you suggest would work like that, would it?

If I could create a map series based on time intervals automatically that would also be useful. e.g. a map for every 1 hour increment over 7 days.

Robert LeClair · Answer

Ah okay now I understand.  Yes, you can do this.  In the Layout, select Dynamic Text, then Table Attribute->Value.  When the "Insert Table Attribute" pane opens, change the Query dropdown to "Map Series Rows" in the Source component, select your Field in the Appearance component and click OK.  When you change the Map Series for each vehicle the dynamic text attribute updates with the name of each vehicle.  See attached image.

Anonymous User · Answer

In the below image I am looking for an automated way to update the red highlighted section. I've had to redact a few sections of the image but the red outlined area is the only thing that can't be updated automatically.