I have a Looker Studio report, which shows data for last week (starts Monday) vs the previous week. The issue is that it’s summing to today, not to Sunday 19th May?
Does anyone know why this could be?
It could be an issue with the date potentially as I had to PARSE_DATE due to the way the date was pulling through.
For reference, the date is the dimension: Charge Processed At
with formula: PARSE_DATE(“%Y-%m-%d”,substr(charges.processed_at, 1, 10))
(charges.processed_at is in the format of YYYY-MM-DDHH:MM:SS as text.)
See the lime coloured tables at the bottom here:
https://lookerstudio.google.com/u/0/reporting/96214614-ac1c-40d4-a879-488904d03486/page/p_z23375zjhd/edit
Any help would be greatly appreciated!!
Requisite Agency is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.