Hi @_Raj , as also @richgalloway and @livehybrid said, your requirements aren't so clear, do you want to have the count of students for each class and for each school or what else? and how do you want to display these results in the same table? probably you could create different panels different searches in a dashboard. Anyway, if you want to have the results in a single table (I don't understand why!), you could run something like this (resusing the data visualization of @livehybrid 😞 | makeresults format=csv data=
"student_id,student_name,class,school,subject,score
1,Alice,10A,School1,Math,85
2,Bob,10A,School1,Math,72
3,Charlie,10B,School1,Science,90
4,David,10A,School2,Math,65
5,Eva,10B,School2,Science,88"
| stats
count(eval(class="10A")) AS 10A_count
count(eval(class="10B")) AS 10B_count
count(eval(school="School1")) AS School1_count
count(eval(school="School2")) AS School2_count Ciao. Giuseppe
... View more