Trying to trend the number of responses in each month over a 6 month period. The banners would be the months (Jan, Feb) and include anyone who was recorded as a complete in that month. Any help is appreciated.

@Kelsodeluca - I do understand your query and here is what you can do to achieve this:In Cross TabCreate 2 embedded variables in survey, one each to capture day / week and other one to maintain the counts. In crosstab feature, we are able to access embedded variables + actual questions but not the count hence this might be a good option...refer to the image below as an example. I have created one day variable which is used at the top.!In ReportsGo to paginated reports [under "Reports" tab --> Reports]. Here you can create a report based on the metadata variable Finished and apply a breakdown by End Date (Month)Hope one of the above works for you

Hi @Kelsodeluca , Where you want to show this response table in excel or vocalise or report.

Trend data by month in crosstab | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded