Dear All,

I am trying to configure a dashboard which is reporting some weekly informations, below is one example:

• Number of leads assigned to a specific business developer:
• • Value of this week
  • Value of the previous week

The data is extracted directly from the CRM app in the following location : CRM > Reporting > Leads. I have configured specific filtering rules from which I extract the pivot table in a spreadsheet. Please find below one example of a filtering rule which looks for leads assigned to a user called Georges from this week's Monday to this week's Sunday:

["&", "|", ("active", "=", True), ("active", "=", False), "&", ("x_studio_bizdev_assignment_date", ">=", (context_today()+relativedelta(weeks=-1, weekday=6)).strftime('%Y-%m-%d 23:00:00')), ("x_studio_bizdev_assignment_date", "

The problem is when I use this filtering rule and insert the data in a spreadsheet, the time period becomes fixed, meaning that it will not be updated dynamically if we move on to next week. The same data will get reported over and over...

See below how the filter domain changes when I look at the pivot properties of the filtering rule :

["&", "&", "&", "|", ("active", "=", True), ("active", "=", False), "&", ("x_studio_bizdev_assignment_date", ">=", "2024-04-28 23:00:00"), ("x_studio_bizdev_assignment_date", "

I cannot find what is causing my domain to become "fixed" when inserted in a spreadsheet.

Could you please help me solve this issue ?

Have a nice day!