1. Why does my Flexible Table export only show some of the rows?
Excel exports will reflect the exact view in Rivia at the time of export. If rows are missing, try expanding those sections and exporting again. Whatever sections you expand should be included fully in the export.
There is also an option to "Expand all" grouped rows as well that can help.
2. How do filtering, grouping, and sorting work in the Flexible Table?
Flexible Tables have two options for adding Filters, Group Bys, and Sorting options. There is a "universal" option up at the top that will apply to the full Table, and there are "local" options available within the individual column. Read more about Flexible Table formatting options here.
Filters
Filters work by removing results that do not apply to the filter added. For example, a filter for Patient: Study is RIV-101-SCL will remove results from all other studies in Rivia from the Table.
Local filters can be added with AND or OR logic. Switch between the two by clicking on the dark blue command bubble.
Universal filters are restricted to AND logic only.
Deep Dive: Universal vs. Local Filters
The difference between universal and local filters lies in the way that data is pulled into the Table. By adding a local filter on the column level, the Flexible Table will avoid pulling entries that meet that criteria into the Table at all. Universal filters will remove values from the Table that don't meet the criteria after the data has been "pulled down" into the Table from Rivia's database. This may lead to blank cells in the Table as the universal filter will work to "clean up" any results that don't fit the criteria, but the placeholder cell may remain. Please note that universal filters will also only apply if the same domain (eg. patient data, AE data) is present in all columns of a Table.
To avoid this, we recommend applying local filters on each individual column directly.
Group By
The Group By option operates the same way regardless of whether it is added universally or locally. Locally applied Group Bys will appear under the universal Group By button, and the order of the Group By hierarchy can be adjusted from there rather than in the individual columns directly.
Sort
The Sort option operates the same way regardless of whether it is added universally or locally. Locally applied Sorting will appear under the universal Sort button, and the order of the Sort hierarchy can be adjusted from there rather than in the individual columns directly.
3. How can I edit the structure of my data in a Flexible Table?
Flexible Tables contain multiple formatting options. A common request is to extract date or time from a data field that is formatted differently.
To edit a column, open up the Editor for the relevant column. Under Formatting -> Display Format, click on Advanced Formatting. Many pre-set data format options exist in the dropdown. Select the one that fits your purpose.
4. How can I extract time from a data field?
For example, in order to extract the time from a data field formatted
April 15, 2025 At 11:43:00 AM , open up the Editor for the relevant column. Under Formatting -> Display Format, click on Advanced Formatting, enter the following formula:
IF(IS_AGGREGATE(), PARSE_DATE(agg[],'hh:mm:ss a'), PARSE_DATE(col[],'hh:mm:ss a'))
The cell should now return 11:43:00 AM as a result.
5. Can I select multiple labs in the Laboratory Summary template?
There is a restriction on 20 lab selections for Tables created with the Laboratory Summary template.
6. What are Domains and Identifiers?
Data is mapped into Rivia using a structure that contains overarching domains, which essentially define the type of data. Identifiers exist within each domain and relate to the type of data that you'd find within a column of a specific data set. This structure replicates the structure of data found in SDTM files. Examples of domains include Patient, Visit, Adverse Event, Exposure, etc. Identifiers can be viewed by selecting one of the nested options under the selected domain.
You can see the list of domains and identifiers that exist for your data in Rivia each time you add a new Event Data Field (column) to a Flexible Table (see image above). You can also view this when adding a new event to any other type of plot in Rivia. (see image below)
7. How many labs can I add to a Flexible Table?
Flexible Tables can support 20 types of different lab results (identifiers) in a single Table. As a result, when creating a Flexible Table using the "Lab Summary by Visit" template, ensure that a maximum of 20 labs are selected.
8. Can I filter rows based on the value of a formula column I created?
Currently, the universal filter only supports filtering by raw event properties and cohorts, not by computed/formula column values.
9. Can I combine multiple cohorts with OR logic in the universal filter?
Currently, the universal filter supports AND conditions. OR conditions are not currently supported.
In order to express "Cohort = A OR Cohort = B", use a column filter with an advanced formula (e.g., IN_COHORT('id1', ...) OR IN_COHORT('id2', ...)) as a workaround.
10. Why are rows where all cells are empty (null) hidden from my Table? Can I show them?
Flexible Tables automatically filter out rows where all column values are null, which was implemented to avoid cluttering views with empty group rows.
11. Why did manually typing certain commands (e.g., col[] or agg[]) in a column or universal filter formula not update in the Flexible Table?
While col[] and agg[] commands are valid in formatting, segmentation, or aggregation formulas, column filters run before column values are computed. Use a View Filter instead to filter by computed column values.
12. Is it possible to edit a Flexible Table at the same time as another user?
If two users edit the same Table simultaneously in Edit Mode, one user's changes will silently overwrite the other's changes. In order to ensure proper edits are saved, please ensure only one user edits a Table at a time.
However, View Mode changes can be made by multiple users at once, as these changes are not saved to the Table once you exit the Table.
13. What happens if my Table query returns more than 10,000 rows?
Flexible Tables have a 10,000 row limit per query. If your configuration would result in more than 10,000 rows being fetched, the system may display an error (eg. "too many rows to display").
If you hit this limit, consider narrowing your data filters or cohort selection. Should you require additional support, please reach out to the Rivia team directly at [email protected].