I am trying to make a KPI chart that contains a specific response within a field. I am using an 'if' function which is going well, however, I want to have the measure in the KPI be the 'count' of another field (one that is not numerical, hence the 'count').
This is basically what I have:
=If(FIELD_THAT_IS_NOT_NUMERIC='Yes' or 'No', count(COUNT_OF_THIS_FIELD_IS_THE_NUMBER_OF_RESPONSES_IN_MY_DATA_SET))
This is not working. It seems to just be showing only when 'Yes' or 'No' were not the response (basically the times nothing was put in). This, which should be similar, is working:
The actual data is regarding whether or not a specific party was declared 'at fault' for an incident. I wanted a KPI that only showed the number of incidents where that specific party was declared 'at fault'.
#An issue was that much of the responses recorded in this category were neither 'Yes' nor 'No' and were left blank or inconclusive in some way (we are aware this is not the best data in terms of consistency but it's what we have) so we wanted a way to display only those values where it was 'yes' (or 'yes' or 'no' for a multi KPI). <Still true BUT, we realized that the data responses we had were NOT actually listed as 'Yes' and 'No' (we have a key that listed the data as such but it was not accurate) but as something else.
So we went in and changed the names of the responses and made the blank responses null and then this function you provided seems to be working well! However! The comma between the 'yes' and the 'no' in your function does not seem to be combining them or making them either/or, but is doing something else. (The 'Yes' and 'No' combined response would be 88.23k, the response with the comma would be 46.82k, and the response of just 'Yes' was 44.47k. Which is a bit odd). But regardless, the single response works well!
So thank you very much! Do you have any particular explanation as to why this works or why the 46.82k occurs so that I may better be able to write my own functions in the future?
Some of my data was labeled incorrectly in the first place so that explains why some things were not working. I got rid of some null values, just getting the data cleaner in general, and this ran smoothly when I ran it with just what would be the 'yes' response.
However, this number is not equivalent to the number I got with some other methods. Another reply provided me with another method, which also works well, but has a different number. I also made a multi KPI that had the numbers of both options (what would be 'yes' and 'no' separately) and the 'yes' number matched the number from the other method.
All the 'yes' response numbers I have gotten:
Your method: 45.41k
Other method: 44.47k
Number from multi KPI: 44k
It is reasonable to suggest that the 44k number is just 44.47k rounded but 45.41k cannot round to 44k.
My point in telling you this is not to be rude or anything but to ask about the 'Match' function. It is the only different function between your replies. So what does 'Match' do in a function? I really appreciate your reply to my original question though so thank you!