Add graph to a Linkview

[uda_chmt]

Hello friends, after more than 1  year, here i come again for your advices and help with my app.

To context all of you, this is a follow-up app for patients in a hospital, and let me assure that all the data shown is dummy as is my test version.

How it works (see attached image please): In the first screen we have a list of patients to follow.
When we click one of them, we see details of the patient. If we scroll down in the details, we see the daily evaluation of the patient. That daily evaluation was made as a REF with REF_ROWS() for a specific table, that in reality links to a system generated view with AppLink LINKTOVIEW("dias 2_Inline")"

When we click on Ver, we see a list of all evaluations performed.

My question is... Can i put a graph in the bottom of the last view, showing the VAS (pain) score, as i draw in the last screenshot of the attached picture?

Sorry for being so descriptive but i believe this is quite complex and even for me, as i created the app 1+ years ago, I feel a bit lost.

Best regards

[Tijesuni]

Hello, @uda_chmt 

Yes, you can add a graph at the bottom of your last view to show the VAS (pain) score over time. Here's how you can do it in AppSheet:

Steps to Add a Graph in AppSheet:

1. Ensure Data is Structured Properly
• Your daily evaluation table should have at least two key columns:
• Date (or timestamp)
• VAS Score (pain score)
2. Create a Chart View
• Go to your AppSheet Editor.
• Navigate to UX > Views.
• Click + New View.
• Set the following:
• View Name: VAS Chart (or any name you prefer)
• View Type: Chart
• Data Source: The table containing the daily evaluations.
• Chart Type: Line Chart (to show the trend over time)
• X-Axis: Date column
• Y-Axis: VAS Score column
3. Embed the Chart in the Details View
• Go to your Patients Detail View.
• Scroll to the Related Evaluations Inline View.
• Add a Dashboard or Slice if needed to include both the table and chart.
4. Alternative: Virtual Column with Inline Chart
   If you want the chart directly in the detail view, create a virtual column:
• Go to Data > Columns > Evaluations Table.
• Click + Virtual Column.

Use the SPARKLINE() function to generate a simple inline chart:
SPARKLINE(SELECT(Evaluations[VAS Score], [Patient ID] = [_THISROW].[Patient ID]))

• Show this virtual column at the bottom of the evaluation list.

[uda_chmt]

I don't know if it was a human or AI generated answer, specially because AppSheet don't even support SPARKLINE() function. 
Anyway, I couldn't follow the suggestion so if anyone is willing to help me with a different approach i would be very thankful

[Tijesuni]

@uda_chmt Instead of sparkline use linktoview
LINKTOVIEW("VAS Pain Score Chart")