Another idea for thought would be to change the data input to using decorated tasks instead of multiple rows. Imaging dedicating various letters to the various moods, and then let the text be a description of why you’re in that emotion. Imaging the following tasks spread out into your daily notes:
- [J] Found the love of my life
- [s] Got the monthly bills, but no money to pay them
- [S] My friends surprised me with a birthday party
Using Checklists - Minimal Documentation you can decorate tasks with various icons, and I foresee having icons for “J - Joy”, “s - scared”, “S - Surprised” through redefinitions of the icons used when decorating the tasks.
This could also be combined with using the Quick Add plugin to have a dedicated macro to inserting the emotion of the day through a hotkey, where you can choose the emotion from a list (which would also help to not having to remember each one-letter combination for an emotion).
The main benefit from doing it this other way, would be two-folder:
You get just one line for the emotion of the day
You can define why that is the emotion of the day
Your queries would be simpler, as you can filter out tasks with your chosen letters for emotion, and then simply use task.status to get the actual emotion letter
It’s also reasonably easy to collate these into a monthly summary, and you’ll get to see the reasons of your emotions during the month
This doesn’t answer your main request though, I just wanted to share something I’ve been doing lately along similar lines, although I don’t have just one emotion pr day, and don’t gather them up into an image like you want to.