Hi
@Kelsodeluca , Where you want to show this response table in excel or vocalise or report.
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.
You can only create pivot table in excel using two columns "month and number of completes" for report you have to manually add.
@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
