Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am trying build a bar chart that count the number of people who delcared Zero income by year. below is the expression I used
If((sum(Income)) <= 0, Count (Distinct [PersonId]))
but I'm getting this error msg "The chart is not displayed because it contains only undefined value"
I tried this expression as well but still no luck:
Count({<[PersonId]={"=Sum([Income]) <= 0 "}>} distinct [PersonId])
Your set analysis expression looks correct. What error/result are you getting with that expression?
-Rob
I'm getting this error "The chart is not displayed because it contains only undefined value" when I add the first expression. the second expression is not returing any value.