Trying to automate the weekly Report

Hi Team,

We are trying to automate the weekly reports, every Friday i would like run this report

  1. On Friday every week Number of issues moved to “TO Do” or “selected to be fixed” Status, this define us weekly scope
  2. Number of issue move to “TO Do” or “selected to be fixed” Status after Friday (next week Monday to Thursday)

Please help me in script for above two use case, i’m very new to eazy Bi