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

[ldave]

I'm glad it helped 🙂 have a nice day!

[Rylie Markle]

Hello again, 

I was able to figure out how to script the number of cases, but I am now trying to only get the number of specific subject persons. Like if there are 3 cases for 1 subject person, I would want that to only count as one. Do you know a way that I could add this to my script? I tried to do it using filters, but I can't think of a way to filter it correctly. Any help is appreciated!!

[ldave]

Hi Rylie, sorry but I didn't see your further question, I hope you already solved yourself, but in case you still need a hand on the topic, I think you can do it with a grouping inside the agregate.

so adding a

agg.groupBy('subject person field name');

before the agg.query();

[JB-Wan Kenobi]

Thanks.