Here is the kind of data I have:
Days to deliver is a table calculation.
Here is the visualization I want:
However, because the ‘days to deliver’ calculation needs each Order Date and Deliver Date combo included in the data table to process, this is the closest I can get to what I want:
Looker seems to require displaying one row for every Order - Deliver Date / Store combination, so if we have 100s of orders this will have hundreds of rows of repeating information. Is there a way to group by store number in this example without displaying superfluous multiple rows? Or is there a work-around?
Thanks for any help!