Count XPATH with Condition
I have a query that pulls all the information that I need from within a given date range. However, now I need to further filter that data. Specifically I need the counts of the rows when a different column is equal to either my inputted string or date (not the one I need to count). When I use the xpath count() though I'm getting a count of the rows when all the data equals "y", and I need the count of the data when the column equals "x" and the column I'm counting equals "y" instead.
Is there a way to use count with a condition?
EDIT: I couldn't find a specific way to do this using count() alone so I just filtered the data with 2 separate mappers then used count() twice.