Report scheduling will allow you to centrally schedule and distribute Grafana Dashboards as hourly, daily, weekly, and monthly PDF and Excel reports. The Grafana dashboard forms the basis of the scheduled report. Skedler will automatically discover all the existing Grafana dashboards for you. You just need to select one dashboard for your report.
- A successful configuration of Skedler settings. Refer How to configure email settings, timezone settings and default logo for reports
To schedule the report, click the Schedule Report button.
Enter the appropriate values in the fields to generate the report.
1. Enter the name of the report in the Scheduled Report Name field.
2. Select the type as Dashboard to schedule the report.
3. Select the required dashboard from the Select Dashboard drop-down to generate reports.
4. Optionally, enter the Folder Path to store the scheduled reports in the Skedler server.
Select the format of the report from the Select Format drop-down. The following formats are available:
PDF, PNG - Inline, PNG - Attachment or Excel.
Note: When the Email setting is disabled, the report is downloaded in the PDF or PNG format.
1. Select the required template from the Select Template drop-down. By default, "No Template" is selected. Refer to Schedule a custom template report based on Kibana dashboard to learn how to design a custom template and use the template for the scheduled reports.
2. Enter the title of the report for the generated PDF report in the Report Title field.
3. Optionally, you can configure the Report Layout based on the report type.
Note: Layout Configuration applicable only for PDF reports.
- Font Family: You can select the type of font in which the report needs to be generated.
- Page size: If the report type is PDF, you can configure the paper size of the report as follows:
- Set the paper or sheet size as Letter, Legal, A4, A3, Tabloid or Default size (Height is 1024 pixel and width is 2048 pixel)
- Select the Page orientation (Landscape or Portrait)
4. Optionally, you can set a logo for the report to be generated. By default "No Logo" is selected. The logo options are as follows:
- Choose Default Logo: If you would like to use the default logo that you configured in the Settings page.
- Custom Logo: You can use a custom logo for this report by uploading logo in the Logo field.
1. Set up the schedule for the report by selecting the Frequency Type as “Hourly”, “Daily”, “Weekly”, “Monthly”, or “Yearly”
2. Enter the scheduled frequency time in the Schedule Frequency Time section to schedule report generation.
3. If the Kibana Dashboard is saved with Store time with dashboard in Kibana then Use dashboard time window option is enabled by default. This schedules the report for the stored time.
If Use dashboard time window checkbox is not selected, Time Window is enabled, which allows you to generate the report for a specific time window.
You can also schedule the email for the report if the Email Setting option is set to “on” in the Email configuration settings page.
1. Enter the recipient email address in the Email To field.
2. To send a copy of the email, enter the email addresses in the Email CC field.
3. To send the generated reports to the recipients corresponding to the filter, select the Include Recipients in Filter checkbox. Refer to Set up Filters section for information on setting up the filter.
4. Enter the subject of the email in the Subject field.
5. Enter the message for the email in the Message field.
6. Select the parameter name from the Merge Parameter Name field. You can merge the parameter names in the Subject and Message fields for the email with the generated report.
7. To send a copy of the report instantly, click the Mail Now button.
8. To save the scheduled report, click Save.
9. If the Email Setting option is set of "off" in the Email Configuration page, you can generate the reports using the Generate now option.
When the report is scheduled, you can view the scheduled report for the Dashboard.