Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to count the records that have values between 0 and 7, I`m using the included expression, but with this one it count also records in negative
count(DISTINCT {<dayss ={'<=7'}>}[CONTRATOi])
I found the solutions..
count({ $<dayss={'>0<=7'}>} distinct CONTRATOi)
Try this:
Count(DISTINCT {<dayss ={'>=0<=7'}>}[CONTRATOi])
the other way,
count(DISTINCT {<dayss ={'0','1','2','3','4','5','6','7'}>}[CONTRATOi])
you can close your thread