Dataview help can't sort or use where condition

[Pat68]

Things I have tried

What I’m trying to do

Hello
I have created this page to consign my workouts
The dataview code seems to work to retrieve all data but the sort or where clause do not work and can’t filter or make stat

Could you please help here ?
Where I’m wrong?

The dataview query is below

---
Title: Fitness +
Creation date: 2022-02-05 13:58
# Tags – Use "#🧘🏻yoga ", "Méditation", "HIIT", "Gainage", "Renforcement", "Pilates", "#ReCup"
# tags: DailyNote/Fitness+ Journal/Date/Day_notes
Tags: #🧘🏻yoga 
--- 

---
# 🧘🏻yoga 
## Séance 
#🧘🏻yoga 
 
When:: 2022-02-14
What:: #🧘🏻yoga 
Who:: Dustin
Duration:: 10 min
Episode:: 64

When:: 2022-02-14
What:: #🧘🏻yoga
Who:: Jonelle
Duration:: 10 min
Episode:: 47


---
# 🌱Meditation
## Séance 
#Méditation 

When:: 2022-02-11
What:: #Méditation
Who:: Cristian
Duration:: 20min
Episode:: 4

When:: 2022-02-08
What:: #Méditation
Who:: Jessica
Duration:: 5min
Episode:: 6

---
# Fractionnée(HIIT)
## Séance 
#HIIT 

When:: 2022-02-08
What:: #HIIT
Who:: Bakari
Duration:: 20min
Episode:: Debutant

When:: 2022-02-04
What:: #HIIT
Who:: Bakari
Duration:: 10min
Episode:: Debutant
      
---
# Gainage 
## Séance
#Gainage 
 
When:: 2022-02-14
What:: #Gainage 
Who:: Betina
Duration:: 10min
Episode:: 10

When:: 2022-02-10
What:: #Gainage 
Who:: Amir
Duration:: 10min
Episode:: 16




---
# Renforcement 
## Séance
#Renforcement 
 
When:: 2022-02-07
What:: #Renforcement 
Who:: Gregg
Duration:: 10min
Episode:: Debutant

When:: 2022-02-04
What:: #Renforcement 
Who:: Gregg
Duration:: 10min
Episode:: Debutant

  

---

# Pilates 
## Séance
#Pilates 
 
When:: 2022-02-14
What:: #Pilates  
Who:: Marimba
Duration:: 10min
Episode:: 3

When:: 2022-02-10
What:: #Pilates  
Who:: Marimba
Duration:: 10min
Episode:: 17

Here the Dataview code

table without ID
When AS "Date",
What AS "Discipline",
Who AS "Trainer",
Duration AS "Durée",
Episode AS "Episode"
From #🧘🏻yoga 

Thanks for your help
Regards
Patrick

[joethei]

Is that one big note, or mutiple small notes in your example?

[Pat68]

Hi Thanks for the quick reply
everything is in one note

The stat or on the back of the page
Thanks

[joethei]

Dataview only works on the page level, so every one of these entries would need to be in its own note.

It may look like a valid table, but there is actually just one entry, with all the values you have in a list.

(sidenote: Tags in frontmatter cannot have the # included)

[Pat68]

Thanks I will try following your advice

[niall]

Someone taught me the following and it works in the Frontmatter - and lets me use the automatic tag lookup.

Tags: [" #tag1 #tag2 #tag3 "]