Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
= Count({<Amount = {">0"}, A = {"0*"} , A -= {"0000*"}>}Id) , will this method exclude values 0000# and include 0# ?
Try this:
=Count( {<Amount = {">0"}, A= {"0*"}-{"0000*"}>} Id)
Hi,
expression looks ok & what is the issue ? can you share the mock data and expected output? Thanks
yes, try it urself
try with below
LOAD * inline [
A
0001
111
222
00002 <<excluded as per pattern A -= {"0000*"}
03 <<included as per A = {"0*"}
];
Count({<A = {"0*"} , A -= {"0000*"}>}A)
I am not getting the desired result, beacuse i want to get the count of id, grouping by id and date(if a same id is present in same date n times it should be considered as 1 count) whereas the same id can be in n different dates, then the count is n.