Forum Discussion
Display vital signs
It definitely is. If you put Date and Time on the axis of the chart, and Diastolic and Systolic in the values it will work. The filter context will be for a specific date with a specific time, which should be only one value. So you can use any aggregator ( min, max, average, etc) and get the same result since it is just the one value. The issue is, what do you want to happen when you have a few rows with the same date and same time, such as:
Doubt you want to sum those. Maybe an Average? Or does Type have a precedence?
It definitely is. If you put Date and Time on the axis of the chart, and Diastolic and Systolic in the values it will work. The filter context will be for a specific date with a specific time, which should be only one value. So you can use any aggregator ( min, max, average, etc) and get the same result since it is just the one value. The issue is, what do you want to happen when you have a few rows with the same date and same time, such as:
Doubt you want to sum those. Maybe an Average? Or does Type have a precedence?
Thanks a lot my friend Anonymous for the kind help. It worked. Now my problem is to format the axis label in a way that the date and time values stay on separate lines. Any idea how that can be accomplished?
Best thing I could think of is just formatting them differently., but there's probably a better way (not my strength)
