Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a column called withinresp, where the result is either going to be 0 or 1. However I would like to know the exact number of the value 0, in the field called withinresp using a text object. Would someone be able to help me with the query please?
count({$<[withinresp]={0}>} withinresp)
=count({<withinresp=0>}withinresp)
count({$<[withinresp]={0}>} withinresp)
if we need to count distinct value then plz help
=count(distinct {<withinresp=0>}withinresp)
Thanks a lot
it is working fine with below mentioned expression
count(distinct {$<[withinresp]={0}>} withinresp)