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?