Chart view of all related rows in Table 2 of row in Table 1

[michael12]

Hi everyone (including @Steve @dbaum ),

I've been trying to slice or filter and not having any luck figuring this out.

Table 1 is Patient IDs

Table 2 is Encounters

So a one (patient) to many (encounters) structure.

1) I want to create a chart view of the encounters of each patient by encounter date

2) Even better if could show up automatically in the detailed view of the individual patient.

Anyone able to help? Thanks so much...

[Marc_Dillon · Accepted solution]

All you need to do is create a chart view, in Ref position, on the Encounter table. It will show up on the Patient detail view, wherever you put the [Related Encounters] column, showing on encounter per patient.

[michael12]

Thank you so much 🙏