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

---