create a scheduled report for a single score report?

[dbrennan]

Hey everyone,

I am trying to create a scheduled report that will return the total number of users in a table I have set up.   I chose the single score type for the report as it returns the current total number of users in the table.   However, for some reason I am not able to make that report into a scheduled report. It is not an available option in the drop down box next to the save button in the upper right hand corner.

Nor can I view the report when I try to create a scheduled report from the scheduled report tab.

Are lists the only reports that you can send as a scheduled report?

I currently have a business rule set up to get the total number of current users in the table however I have it set to run and fire an event whenever someone is added or deleted from the table.   I only want this report to be sent once a week however and that didn't appear to be an option when I created the business rule/event/notification combo.

Any advice on how to do this as cleanly as possible?

Thank you,

Devlin

[Sri61]

Hello Devlin,

You cannot schedule a single score report and this behavior is intended.

Also these are the types of report that cannot be run as a scheduled report

1) Calendar

2) Multilevel Pivot

3) Map

4) Single Score

Hope this info helps.Thank you.

Kind Regards,

Sri

[jwawa]

Thanks for the info, Sri.   One clarification and some additional comments...

Multilevel Pivot reports can be scheduled (as PDF or PNG image) (at least as of Jakarta and Kingston, I'm not sure about older releases).

The Schedule option is present but when clicked, you'll get a popup message that reads "You must enable the WebKit HTML to PDF plugin (com.snc.whtp) to export/schedule this report visualization."

Once you activate the "WebKit HTML to PDF" plugin in your instance, however, you should be able to schedule MLP reports.

Docs does state that "Map reports cannot be exported or scheduled as PDFs, but can be saved as images."

The Docs site incorrectly suggests that Calendar and Single Score reports can be scheduled when it mentions scheduling in the "What to do next" sections.   I've submitted feedback asking the Docs team to correct that, so it's not misleading.

Thanks again for the info.

[jwawa]

Hey Devlin,

I know this is a few months old now, but you should be able to use a report type of Speedometer or Dial.

They're not quite as clean/simple as the Single Score, but I think they might be a good option for you, and these can be scheduled to run weekly like you're wanting.

-Joe

[ldave]

Hi, I'm 5 years late, but I've faced the same issue (I like when the issues are explained as intended behavior, and even though we get a new release every six months, things like this aren't even remotely looked into).

Introduction aside, you can get almost the result you need (thus having a total sent to you via email) via scripts.

It will not be a png or similar, but if you already have a connected report that sends things to you, you can add a mail script to the body of the mail and in the mail script you can define a glide aggregate or a simple glide record to count the total rows and have then those added as text to the email.

I hope it helps.