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

 

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:

 

 

0 2 245