Goal is to log my daily activities, water intake, vitamins etc. into Obsidian to check how those relates to my mood and energy levels. I envisioned to feed my daily notes with some data which then can be merged to build a table/database to get some insight.

Dataview plugin came to my mind. Using Dataview plugin you can simply add some data and query for it - list it or let Dataview make a table.

For my purpose I'm going to use Inline fields syntax in template for my daily notes.

[key:: value] Legend for value (Rating 1 - 5); True/False

To know how to fill in the values each day I will write a legend after each pair.

To translate the data to table view I will create new file with below code block.

```
dataview
table key_1, key_2
where file.folder= "Daily"  
sort file.name desc
```

Output:

Values examples

• Rating 1 - best to 5 - worst
• True/False - Tracking of specific sport activities eg: Climbing :: True
• Values - For steps, water intake
• Comment key for any comment. If more then divider is semicolon

Analyze?

Do not know yet how to, though below is first idea that came to my mind.

This output can be analyzed further. My idea is to feed the AI (through I am sort of anti AI as it might use data against me in future...)

Prompt would like:

Analyze below daily data which I log daily. Find relations.

<Insert table>

Purpose of those data I am logging daily is to <find relationships between them that might lead to improvements>. Suggest what else I should track in case I want more in depth analysis.

For context below is legend for each column explaining data type and or rating in more detail

<Insert legend>

Next steps?

• Connecting to external tools like Garmin or Strava to get activities, steps, weight.
• Tracking of mood - mood can change during the day and for better granularity it would be good to track the time mood switched to different rating. In summary view then do the avg. of each day. Due to complexity and how I feel overwhelmed just by little googling solution it will be just nice to have. Should you have simple solution, let me know.