I added in the domain -> Derived Tables, this sql: SELECT customer,sum(txes_count), DATE(adddate(`usage_day`, INTERVAL (0-weekday(`usage_day`)) DAY)) as week_date, usage_day FROM tx_daily_count group by week(DATE_SUB(usage_day, INTERVAL 1 DAY)), usage_day but I can't select sum(txes_count) in the report as a Measure I get an error: An error occurred while performing the previous request Can you help me? Thanks