Am trying to create a program indicator with multiple And/Or conditions. In the past I have not had a problem applying either multiple AND or multiple OR conditions to program indicators on their own. Now I am trying to combine And/Or operations in the filter and seem to be having a bit of difficulty. As an example, I am collecting information on different types of confirmed malaria. The program indicator can meet several of these confirmed malaria conditions to be true so I use OR. I also only want to filter out female cases < 5 so use AND; have tried a couple ways as attached. Any advice would be sincerely appreciated. Am using count as my aggregation operation and event count as the expression. While I do get a data value when I check this in pivot tables, the value is very different then what I see when I apply the same filter in event reports.
Hi Nick!
Generally the grouped and/or filter should work, and we will have to dig deeper to find the cause here. Can you send me your database offline?
Am trying to create a program indicator with multiple And/Or conditions. In the past I have not had a problem applying either multiple AND or multiple OR conditions to program indicators on their own. Now I am trying to combine And/Or operations in the filter and seem to be having a bit of difficulty. As an example, I am collecting information on different types of confirmed malaria. The program indicator can meet several of these confirmed malaria conditions to be true so I use OR. I also only want to filter out female cases < 5 so use AND; have tried a couple ways as attached. Any advice would be sincerely appreciated. Am using count as my aggregation operation and event count as the expression. While I do get a data value when I check this in pivot tables, the value is very different then what I see when I apply the same filter in event reports.
