Category Comparison Graph

Hey Everyone,

I would like to compare our categories of Call Intent Types by day, looking at one particular category’s calls versus the total calls.  I would also like to do this comparison by Division.  I have created a FAKE DATA set that illustrates what I mean.  Any help?

In the REAL data, that spans a full year, and over 30 categories, we are looking to see what categories experience abnormal spikes and on what days, or times of the year.  At first, I did it in a crude way: I created two pivot tables: one pivot table with the total call intents by day, and then a second pivot table and slicer so I could select a specific category (or several) and compare to the day.  A third section would do a ratio of the other two by date.

One problem I had was that some days do not have any calls for a particular category, so the table-to-table comparison would no longer line up to the day… for graphing purposes, etc.

Thanks!

John