Best answer by Swanand_Chavan_Ugam
View originalTrend data by month in crosstab
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 Tab
Create 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 Reports
Go 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
In Cross Tab
Create 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 Reports
Go 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
You can only create pivot table in excel using two columns "month and number of completes" for report you have to manually add.
Hey @bansalpeeyush29 ,
Ideally both within the report and excel. I know I can simply export the data filtered by data and create the table in excel. Just hoping there is a simpler solution.
Ideally both within the report and excel. I know I can simply export the data filtered by data and create the table in excel. Just hoping there is a simpler solution.
Hi @Kelsodeluca , Where you want to show this response table in excel or vocalise or report.
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.