I’m trying to do something that seems very common. In the below example (thought I don’t need quite this many things at once, this is just a good example), there’s a month-to-date line for sales this month, overlayed on last months sales.
That’s a common pattern I’ve used in other tools to track how we are doing versus last month. (This one also has a nice goal line feature, but that’s a topic for another post…)
By doing a pivot on the month and selecting two months, I can get them both plotted, but they aren’t overlayed, of course. They are next to each other, like this:
I want that graph, but have the October data compared directly to September data.
Is there a common Looker-community pattern for this?