I am a newbie to Splunk, I have found that I have been able to re-create most of my reports and build them out into a usable dashboard or report. I have one that I just cannot seem to get correct or all the information into the correct way. So here is what I have (Source) email=*, recipient_group="*", reported_phish="*" | timechart count(reported_phish) by recipient_group This gets me real close,it will split out the report into the three departments and give a total of all the email phishing scenarios available in the reported_phish field in grand total. If I change the reported_phish="Yes" I get everyone that has reported the phishing test or if I use reported_phish="No" I get the same for the people who have not reported the phish email, so I believe that the data I need is there for my graph. What my final outcome would be is have the chart where every department has the count of yes or no answers in a total. below shows the grand totals and I would like to split the department to reflect yes and no along with the grand total. Again I apologize for not being able to find the answer. I have tried to split, append, different charts from the community and google and I am just drawing a total blank Thank You in advance Jeff
... View more