Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Aggr(Count({<Amount = {">0"}, A = {"0*"} , A -= {"0000*"}>}Id) ?
maybe it's simple as Count( {<Amount = {">0"}, A = {"0*"} , A -= {"0000*"}>} Distinct Id & Date ) ?
distinct id, for a particular day, is fine(it will give single count). But for different days it should be treated as another count
The above should be counting an id on another date as a new observation... have you tried it already?
you can Make a new field hash128(ID, Date) as Newfield and count distinct
yes it does.