Topics started by robert.grace
Comparing results between time periods can often seem daunting at first glance. Many people fall down the rabbit hole of stacking many calculations into one table using offsets. While this can be fast and efficient for very sophisticated developers, it can also make coding and visualizing tedious. Furthermore, since these calculations are created in the explore layer, the more complex the calculations become the more crucial it is for power users to coordinate their development to maintain a single source of truth. Fortunately, with Merged Results and some creative self-joins, Looker can do these types of comparisons for you in a quick and governed fashion! The crux of this approach revolves around three instances of the same query joined to itself using the power of merged results. For our primary query, we want to create a result set with 4 total fields: the order created week, the week directly prior to that period, the week 52 weeks prior to that period, and the order count of the
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.