AnsweredAssumed Answered

Sub Summary Based on Date Calculation

Question asked by sccardais on Mar 7, 2014
Latest reply on Mar 7, 2014 by philmodjunk

Title

Sub Summary Based on Date Calculation

Post

     I want to create a sub summary report based on a date calculation.

     The attached layout has two sub summary parts.

     The first summarized by Edition.

     The second by the calculation field Survey_YYYY_Mo. This field is based on another calculation field (Date_Convert) that converts a timestamp to a conventional date. Survey_YYYY_Mo converts Date_Convert to only the year and month of the survey because I want them grouped by Year and Month to track trends.

     The goal is to identify trends for each version of the product over time based on the year / mo the surveys were taken. e.g. if three surveys were submitted in Feb 2014, their results would be summarized into a single row 2014 - 02.

     I'm sorting by Edition and Survey_YYYY_Mo but instead of getting summary data below each Edition, I'm getting one row with a question mark ? in the Survey_YYYY_Mo field. I would expect each version to have multiple rows - one row for each group of surveys by year - mo they were taken.

     Can anyone tell me what I'm doing wrong here?

NPS_by_edition_over_time.jpg

Outcomes