Viewing results of more than one campaign at a time (by date range or series?)
I am currently running reports of campaign results and letting management know which users failed and which have not taken training. We are currently running a series with weekly campaigns. I need to view / sort / report from multiple campaigns for the management reports I am generating. I currently have to go to week 1 campaign results, and export them. Then I go to week 2 campaign results, export them, cut/paste and add results to week 1, then on to week 3, etc. Once in excel, i can sort, pivot table, filter, etc. but getting the results exported is difficult. Especially seeing management wants results reported every other day. Their expectation is to walk over to the user and sit down, look at the emailed (aka Attack) the triggered the "failure" and educate them in addition to encouraging them take the training. I would like to be able to enter a date range and download all results for that date range or enter a series (instead of a campaign) and look at ALL the results of the SERIES (which could be many campaigns) at one time.