Bug with Comparison Date Range

Comparison Date Range is not working on tables. I have a metric in a table where Date Range is set to last week and Comparision Date Range set to Previous Period. The difference of 6 should appear in the table however it does not.

When i change the table to a Scorecard, the difference of 6 DOES appear.

2 Likes

I was able to replicate the issue. With the same settings on a scorecard and table, the comparion showed up for the scorecard, but on the table I only got nulls for the delta.

I’ll investigate this further and let you know if this is expected behavior, or if there’s a solution.

3 Likes

Although, when I changed the granularity of the table to Week, then the delta did properly appear:

hi, I had the same problem. I set the ‘default date range’ and ‘comparison date range’, but the delta was null. When I removed the date dimension from the dimension list of my table, the delta appeared.

Hi all,

Same issue for me, is there any way to native delta evolution on dates dimension in Looker Studio tables ?