Hi, but I did not get the correct value for my total score. How to filter and count the all same value in the database but different fields
import wixData from 'wix-data';
$w.onReady(function () {
wixData.query("DISC")
.eq("no1Q","D")
.eq("no2Q","D")
.eq("no3Q","D")
.eq("no4Q","D")
.eq("no5Q","D")
.eq("no6Q","D")
.eq("no7Q","D")
.eq("no8Q","D")
.eq("no9Q","D")
.eq("no10Q","D")
.eq("no11Q","D")
.eq("no12Q","D")
.eq("no13Q","D")
.eq("no14Q","D")
.eq("no15Q","D")
.eq("no16Q","D")
.eq("no17Q","D")
.eq("no18Q","D")
.eq("no19Q","D")
.eq("no20Q","D")
.eq("no21Q","D")
.eq("no22Q","D")
.eq("no23Q","D")
.eq("no24Q","D")
.count()
.then((results)=>{
$w('#sumD').text = results.toString()
})
});