This function allows the export of multiple report data. Since each report template can be downloaded, data can be exported across projects, allowing for monthly data aggregation, etc.
Note: This function is available only to those who have subscribed to KANNA Report and Export function.
1. Click on [Export].
2. Select the [Custom Report] tab and click [+ Create export file].
Note: If you have not subscribed to the [Export] option on KANNA Project, only the Custom Report tab will be displayed. Click on “+Create export file”.
3. After selecting a file name and template to export, click on [Save].
4. Export file creation complete
You can download it from [Download CSV] on the upper right corner.
When exporting a form that uses the input item “check box
When a form with a check box is exported, the following values are displayed in the export file.
With check box: TRUE
Without check box: FALSE
These values can be used for tabulation by using functions. 1.
1. example of a report using check boxes
2. Exporting a form with checkboxes
The value is output as TRUE (checked) / FALSE (unchecked). 3.
3. When a function is used in the exported Excel file
If the IF function is set, the display can be changed according to TRUE / FALSE.
For example, enter =IF(E2=TRUE, “Completed”, “Incomplete”) in F2
If E2 contains TRUE, “Completed” will be displayed; otherwise, “Incomplete” will be displayed.