I am trying to create a graph like the example below.
The data is averaged by "day of therapy" (e.g., 1, 2, 3...), then the day's average is graphed.
Any tips on how to calculate the average of a value on a particular day of therapy? Do I need to calculate the "day of therapy" in my SQL query, or can Qlik handle it? Then, how would i create a graph like the below?