Why am I seeing different values when I have totals turned on then when I don't?

[LookerExperts]

Knowledge Drop

Last tested: Apr 23, 2019
 

Since totals require an extra sql query, the query is different then when totals are off and so explores with totals have a different cache then explores without totals. So it could be that results are pulling from two different caches. Try "clear cache and refresh" on both the non-totals explore and the totals explore.

This content is subject to limited support.