ISOWEEK broken order, correct for most graphs broken in some.

[MarcoSBS]

Hi everyone,

I’m having an issue with the display order of ISOWEEK when using different charts in Looker Studio. Specifically, I’m using two different types of charts: a table and a histogram. I’ve set both charts to sort by ISOWEEK in ascending order.

The expected order should be: Week 22, Week 23, Week 24, Week 25, Week 26, Week 27. However, in the table, the order is incorrect and appears as: Week 24, Week 23, Week 25, Week 26, Week 22, Week 27.

Both charts are using the same data source, which is a blend of two Search Console connectors provided natively by Google.

In both graph I'm pulling data from 2 years from 20230101 to 20241231, using then calculated field generate the distribution.
For the table which is a delta:

(
    SUM
    (CASE WHEN YEAR(Year (it)) = 2024 
        THEN COALESCE(Impressions (GSC .com),0) 
        ELSE 0 
    END )
-
    SUM
    (CASE WHEN YEAR(Year (it)) = 2023 
        THEN COALESCE(Impressions (GSC .it),0) 
        ELSE 0 
    END )
)
/
    SUM
    (CASE WHEN YEAR(Year (it)) = 2023 
        THEN COALESCE(Impressions (GSC .it),0) 
        ELSE 0 
    END )

For the histogram:

(
    SUM
    (CASE WHEN YEAR(Year (it)) = 2024 
        THEN COALESCE(Impressions (GSC .com),0) 
        ELSE 0 
    END )
+
    SUM
    (CASE WHEN YEAR(Year (it)) = 2023 
        THEN COALESCE(Impressions (GSC .it),0) 
        ELSE 0 
    END )
)

I can’t figure out why the table is displaying the weeks out of order, especially since the histogram chart displays them correctly.

Has anyone encountered this issue before or have any suggestions on how to fix it?

Thanks in advance for your help!

Screenshot:

Show More

[sam8]

Thanks for the detailed post!

I noticed something strange in the screenshot. It looks like you're ordering by the SUM of Iso Week, rather than the dimension. Can you try swapping that out for the dimension and see if that helps?

[MarcoSBS]

Hi, thank you for looking into it. It's something that troubled me as well, but there is no metric with that name, I'm simply selecting the ISO Week dimension from the left table  for ordering ( I'm reporting the Blend Structure via screenshoot). ISO Week is a duplicate of date but converted in ISO week by selector in the field area of the Data Source.

As suggested i tried to remove "the sum of ISO Week" and re-select the dimension but with no different result.

So I don't really know how to tackle the problem.