Comparing Year over Year Data with Multiple Source Table

Question

I am attempting to compare data from a current survey (fielded for the past 3 weeks) and one that fielded roughly 1 year ago for about 3 weeks. I have mapped the 2 surveys as sources in the dashboard.  Most of my data is in matrix questions and we want to report out top 2 box percentages with year over year comparisons. Using multi-source tables has been challenging because I want to compare data to last year’s survey and have run into limitations on the “previous period” comparison.   If I include responses from say... "this year" or "past 180 days" it works, however once that time has elapsed (180 days pass or it turns over to a new year) this comparison is no longer valid and the data changes on the dashboard.  My survey has quite a few matrix questions with a lot of rows - so 50 or more rows to report on.  I have thought about putting each row in a separate simple table widget and creating custom metrics for the year over year comparison.  However, this involves creating 50+ widgets and 50+ custom metrics. With that many widgets the dashboard looks very segmented and hard to read and takes a long time to load.Can anyone think of a solution to this issues?  I'd love to use the multi-source table if possible, but am concerned with the time frame comparison.Thanks all for your help!

SabrinaC · Answer

Brian,I haven't worked with the multi source tables much, but for the simple table widget, you could create Field Groups for your matrix questions in the dashboard data.  This would allow you to create a simple table with multiple questions using the Top Box/Bottom Box metric. We categorize our questions in the field groups and name accordingly to easily identify in the dashboard widget creation. Once you create on simple table, you can copy and then change the x-axis to your next field group.Hope this helps,Sabrina

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded