Issue with ISO Week Order in Google Looker Studio Graph

Hello everyone,

I'm encountering a display issue in Google Looker Studio with a graph that tracks impressions per ISO week.

The problem: Some weeks are randomly swapped, disrupting the chronological order. For example, the week of January 13, 2025, appears in the middle of November 2024, while the most recent week, November 18, 2024, is positioned at the far right.

This makes the trend difficult to interpret. Has anyone faced a similar issue or found a solution?

Thanks in advance for your help!

image-01-29-2025_02_19_PM.png

 

Solved Solved
0 2 266
1 ACCEPTED SOLUTION

I believe this is a line graph and not a time series right? Can you check what you are sorting by? Pretty sure you'd want to sort by AVG(dates) and not any other metric that oculd lead to such an issue

View solution in original post

2 REPLIES 2

I believe this is a line graph and not a time series right? Can you check what you are sorting by? Pretty sure you'd want to sort by AVG(dates) and not any other metric that oculd lead to such an issue

The issue was indeed the use of line chart instead of a time series chart. Now it is fixed and looks accurate. Thanks very much !