Daily Reports
How to configure reports?
Reports in StatStream helps you to stay informed about your key parameters in a handy excel report.
-
You can schedule excel reports on daily basis.
-
You can also upload your custom excel template file to schedule the reports.
-
Click on the Administration tab on top right corner.
-
From the left side panel, click on Reports.
-
Click New Report button on the top right corner, then click on Daily Report.
-
Enter suitable Report Subject for your Report. Select Report type as Excel and sheet name as data (this is where your data will get imported).
-
Set Take data since last (Hours) value as per your requirement. Set the daily schedule and timezone.
-
Enter email address/s of the required users/members. Reports will be sent to these emails.
-
Select the required Variables from the dropdown list to send in reports.
Note: You can select multiple variables from the list.
-
Click on Save button.
Note- All reports will have "Epoch Timestamp". You need to refer the below video in order to create a template that follows dd-mm-yyyy hh:mm format along with other customisations.
-
Refer to the below formula to convert epoch time to dd-mm-yyyy hh:mm format in your excel file:
-
=IF(data!A2="","",((data!A2+19800000)/86400000)+DATE(1970,1,1)) - This formula helps you to convert epoch time to standard date/time format in IST timezone (dd-mm-yyyy hh:mm).
-
=IF(data!B1="","",data!B1) , =IF(data!C1="","",data!C1) and so on (as per the count of your parameters columns in excel sheet will increase)- This formula helps you to copy your raw values from "data" sheet to your "Final report" sheet.
-