A chart per record?

Hey @twoshay!

Not a n00b question at all! I definitely see the use case here.

For our use case, we can use a Look or Explore with store IDs that is limited to 20 rows, sorted by most recent monthly total. This accomplishes “Query A”.

For our approach, we can use the link parameter within the definition of the store ID dimension. Here’s a link to our documentation on that parameter. Of particular use to us is the example for passing liquid values into links.

We can use the url parameter within the link, using a Look ID for a Look with the daily sales values, and the expected visualization set (here we use 1). The {{ value }} liquid HTML variable will automatically populate with the ID of the selected store, and the Look will then filter on that store ID.

link: {


   label: Daily Sales Values Chart


   url: "/looks/1&f[stores.ID]={{ value }}"


}

Here’s a link to our documentation on liquid variables that goes in more depth on other options for value.

The Look that we link to here accomplishes “Query B”.

Our Help Center also has a great resource on Custom Drilling Using link, which you can find here.

If you’d like to dive deeper into a specific use case, feel free to reach out at help.looker.com!