Skip to main content

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.

      Daily Reports

How to configure custom excel report template