I’d really appreciate some help putting together a query. I’ve tried but struggled to get started with them.
I have this content on the page where I track my workouts:
- Logs:
- [[Thu Mar 2nd, 2023]] - Legs #workout
- [[Sat Mar 4th, 2023]] - Upper body #workout
- [[Tue Mar 7th, 2023]] - Legs #workout
- [[Sat Mar 11th, 2023]] - Upper body #workout
- ...
I have a goal of 50 workouts by July 1st.
I’d like to write a query that will:
- Count the entries in that list.
- Print out this message:
Today is 2023-04-18 and there are 74 days and 10 weeks until July 1st
Workouts per week to hit your goal: 2.2
20/50 🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜⬜
Where the number of green boxes are the number of entries in the list (20), and the whiteboxes is the number remaining to hit my goal (50 -20).
Thanks in advance for any help.