ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: First occurrence of a field Ahh I see. Thank you so much! Re: First occurrence of a field Unfortunately as database users, we don't have access to Data Models or modifying SQL. We can only edit scripts for each widget or overall dashboard. First occurrence of a field Hello. I work with healthcare dashboards. For the data elements that have one-to-many relationships, is there a script for a widget, so that the table within the widget only selects the first field of that data element? For example, there's a data element called "secondary provider impression" that can have "cardiac arrest", "chest pain", or "cough", etc. But I only want the table/dashboard to show the first value that is not null. Thank you!