How to fix the #weekdiff# and #monthdiff# parameters which are not working properly?

How to fix the #weekdiff# and #monthdiff# parameters which are not working properly?

The SQL query generated by the KPI when last X period filters are used is referring the 'Last X period' queries that is defined in the 'admin_db2_warehouse.xml'. To achieve desired results as per your requirement, please alter the equivalent queries in the 'admin_db2_warehouse.xml'. If you require further assistance, please contact the support team.