I have cognitive data from Cambridge Brain Sciences (4 scores: c-score, reasoning, verbal and memory) which I gather every day, a couple of times per day.
I then have things like: hours slept that day, sleep phases, etc.
Next to that, I have supplements I take on a given day (or I don’t take).
I am wondering how could I combine all of this data in the same graph in a meaningful way. At the moment, I am tracking CBS data in a google spreadsheet with some basic graphs, but I don’t know how to also draw nr of pills (and type) and hours slept (and duration of each phase) all in the same graph for easy correlation.
If that’s not possible, how would I create the google graphs for the pills take for example? At the moment I have a table such as this:
Date | Supplement | Count | Amount (per 1 unit) |
---|---|---|---|
2019-10-10 08:00:00 | Magnesium | 2 | 100mg |
2019-10-10 08:00:00 | Vitamin C | 2 | 1000mg |
2019-10-11 09:00:00 | Omega 3 | 3 | 500 EPA, 250 DHA |
2019-10-11 09:00:00 | Magnesium | 3 | 100mg |
But I’m not sure what graph in google spreadsheets could display, on a per-day, per-hour detail, what did I take and how much. Any ideas?