Really complicated graphing... I think.
Hey there. I'm working on a migraine journal for folks in my family. I looked for a premade one and none of them hit all of the data we need and could organize it how we needed it organized.
What I've made so far has, like, a million data points. The graphs are all split by the day which goes along the top. Under each day there is an entry for each kind of food - whether or not it was ingested that day - as well as markers for pre-migrain events, sleep, stress, exercise, drugs, herbals, supplements, migraine events, pain, quality, aura, other features, etc. I got it to sync between desktops and phones/pads and that is fantastic. Largely, this is all as check boxes. If somebody eats aged cheese that day, a box is checked. If they took a nap that day, a box is checked. Some things have steppers. Stress levels are entered as a 1-5, as is sleep quality.
Now, however, I'm having a really hard time figuring out a good way to visualize relevant data.
I currently have five charts spread across three sheets: Diet, Wellness, Induction, Events, Medication. I'd like to make a fourth page that visualizes the data. So, for example, a long graph with dates along the bottom that shows 1) when a migrain occurred and 2) all relevant events (from Diet, Induction, and Wellness) that happened in the week leading in. I want to leave out some zero data. If the user didn't eat chicken, there's no need for a representation on the graph. However some zero data I do want; if they didn't wake naturally that day, it might be an important variable.
I have no idea the best kind of chart to use, or how to program it. I ended up with one super long graph (400 inches) that followed the timeline over the next few months and was actually visible. But, it wasn't really useful. I'd love any and all thoughts. It's a tall order, I think, and this is not my forte. I'm not a big data analyst.
JH