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.