hello. I currently have a report that lists questions from a checklist followed by a value (sum of times people said no) distributed by regions. I'd like to be a able to say if a question = x and value > 0 then mark the value a different color.
I tried multiple ways but kept getting a non-aggregate and aggregate error or cannot check for Boolean and aggregate. The attached picture shows that the right values have been highlighted as red but they are placed next to the values on the report; no sure how to get them to be on the report.
Hi Dhruv,
This was a partial solution. I only wanted to highlight things that are greater than 0 only for those two questions. My team was able to resolve this by setting the field as an Attribute from a Dimension - that did the trick. Please see attached screen shot
