I'm not sure I understand your goals -
when you created separate fields for yes and no you end up with 2 values measures that are plotted separately on the viz -
you have Yes/No as the value in your dimension Call so you already have that breakout and all you have to do is count or sum records as the measure \See below
I've plotted it at the reason/month/call level and I included call as a filter
if you filter out the no's the plot above becomes
Let me know if this helps
Hi Jim -
Thanks for the response. I have made some progress on this by adding in two calculated columns at the source to look at the Yes/No field and add a 1 in the respective column if there is a match -
i.e =IF(B2= "No", "1", "0") will put a 1 in the "No" column I created if the Yes/No field has a No, otherwise it will put a 0.
I am now using that field to calculate.
I could get to what you have above - the issue I was having was when trying to convert the bar graph to shapes and that not working correctly.
The end goal is to get a chart that looks like the following - I think I'm about 95% of the way there, although I feel my methods are kind of kludge, and I don't quite understand what the message at the bottom right which says "994 nulls" is about.
Basically I want to replace the bar graph with some icons to demonstrate the difference between if people indicate they called in or not.
As I mentioned - I assume this can be done by looking at the Yes/No field and calculating the results, but I had to add in two new columns to the source to count the responses and get the below results.
Hope this makes sense and thanks!
think there are 2 issues - 1 is using custom images to replace the bars - I'm not your guy here - others are more adept at that
The second is that your approach has produced 994 null values - when the formulas you are working with don't result in a true value the produce a null - if you are OK with that there is no issue - but I would make sure they are doing what you think they are