Filter Screen

  Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic! Mail us feedback on this topic!  


When running most reports, you will first be taken through a filter screen.  At the very least, this filter will ask you to specify the date range of the report you are about to run.  Some reports give you the option to sort the results on any field you desire; others will allow you to include only specific demographics, gender or ethnic groups.



Report Filter


This screen allows you to define the specifications you desire for each report.  Demographic and Gender selections help you focus on the particular respondent attributes you wish to print.


The Start Date will be used to include data from that date forward in rolling averages reports.  Filters that request only an end date will use that date as a base for week to week trends.  Based on the End Date, that day and the 6 days prior to that will be included in "This Week"; 7 days before that will be "Last Week", etc.


The End Date should be today, or the last day of the research cycle that you want to include in this report.  If you're running reports at the end of each research week, and you never go back to previous weeks, it's simple enough just to put today's date in the End Date box and rest assured that you've included all data.


If, however, you are going back to a previous week's data... even if it's just last week... the dates you enter in both boxes are important.  For example, let's say you always begin a research week on Monday and end on Thursday.  If you go back to a previous week and (inadvertently or intentionally) put a Start Date that is a Tuesday, all the data from that week's Monday calls will become part of last week.  And the data from the Monday before will become part of Two Week's Ago's data... even though it's really from last week.  The reason for this is that every single score for every song is stored with the date from which it was collected, not from any particular broadcast week.  This is most important to stations researching currents.  Sometimes the weeks might run together, and before you know it, a score you got on a song last Monday is already week-old information.  ComQuest knows this, and will put that information in the Last Week column, rather than including it with This Week's information (provided you, of course, have entered the Start and End Dates properly).


In the case of reports that put results into discrete weekly trend columns, you will only be asked for the End Date.  The report will count back through all the results from this base End Date and put results from the last 6 days (plus today) into the "This Week" column, results from 7-13 days ago into the "Last Week" column, from 14-20 days ago into the "2W" column, etc.


HandIf you are using cycles instead of 7-day weeks, you will see the start dates for each cycle at the top of the column.


Rolling Averages reports allow you to combine results from multiple days (or weeks or months) and design your own composite test period.  In this case, you will be asked to specify the Start Date and End Date for the report you are running.  All scores for any songs that were tested during that period will be included.  So, if you run a rolling averages report for the last month, you will see all songs that were tested during that period, not just the ones you tested this week.


HandComQuest calculates scores for each song based on the number of available scores for that particular song.


This means you can change song hooks, even while a test week is underway, and you'll see the result for each song based on the in-tab scores available for that song (as opposed to calculating the score based on an aggregate total of scores among all songs).


Tie Scores


In the case that two or more songs in a report you're running have the same score (for the attribute on which they're being sorted), those songs will be listed with the same rank order.  After all, they're the same score.  This numbering convention will continue until which time the next ranked song (now with a different value) is encountered.  Then, sequential numbering resumes, picking up where the rank order would normally be at this point.



Example of tied ranking


In the example above, three songs all have a score of 97.9, so they are all ranked as song #8.  Then, when the next different value is encountered, 96.9, that song is ranked as #11, which would then be the next sequential ranking for that song anyway, if the none of the songs above it had been tied.


Report Destination


Most Report Filter screens will give you the option of how you want your results displayed; to the Screen or to the Printer.  In addition, many reports will give you the option of creating a PDF file of the report, after it has either been printed or displayed on the screen.


HandThe filter screen will remember the destination you selected for the last report run on this computer.


That means, if you selected Screen as the destination for the last report you ran on this computer, that destination will continue to be selected automatically for you on all successive reports you run, until and unless you change it to Printer.  This is helpful in the case that you want to run a series of reports all to the same destination; you don't have to remember to click the same destination for each report.


See Also

Override Settings