Scheduled reports are aggregated even if the card shows data on a daily basis?

Joe_M
Joe_M ⚪️

Good afternoon,

Is there a way to have scheduled reports to display data on a daily level? Cards that show monthly data at a daily granularity level can be exported to a .csv/.xlsx at that same level of granularity; however, when distributed via Scheduled Reports, the data comes through at a monthly aggregate level.

Can this be changed so that Scheduled Reports show data at the same level of granularity as the cards?

Thanks!

Answers

  • GrantSmith
    GrantSmith Indiana 🥷

    @Joe_M

    How was your scheduled report created? Was it being viewed in a monthly aggregation when it was created or a daily aggregation?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Joe_M
    Joe_M ⚪️

    Good question - I need to confirm with the scheduler. As the reports themselves default to a monthly view, I'm guessing the reports were scheduled at the monthly level.

  • Joe_M
    Joe_M ⚪️

    Ok, so I just tested this out: I've set the date grain to show me two months of data at a daily level. The email I then get shows the following:

    The following filters were applied:

    Last 2 Months, by Day

    The card in the email also reflects this date grain. The attached .csv though shows the data in a monthly rollup.