Is there no way to fill in missing dates on an explore before merging when I want to picot by another dimension after the merge? I am reporting on a metric that can exist on three different tables in looker. I need to sum all three to get the accurat...

Hello, I have an accounts table that has a signup date and a cancel date. I want to see total amount of active accounts on particular months to create a visualization. Each account will have multiple months of being active defined by the start and en...