Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a data set that has the following:
Requesting Agency and Servicing Agency
I am trying to plot the count of times of servicing agency, when the requesting agency = 'JAY'.
Here is my code:
=if([Requesting Agency] = 'JAY',count([Servicing Agency]),1).
It works fine, however, if the Servicing Agency is = "jay" it also plots it. How do I exclude that value from being plotted.
For this simple if statement, try to use set analysis:
Count( {<Requesting Agency={'JAY'}>} [Servicing Agency])