The main goal of my dashboard is to display how many accounts add an additional product by the end of a given year.
For example, in 2021, let’s say there are 100 accounts that start the year with 1 product (and were still active at the end of the year), and by the end of the year, x accounts added 1 other product, or 2 products (and what are these products).
Product 1: 10 districts
Product 2: 5 districts
Other products etc
I helped run salesforce reporting to put the data in google sheets and then created formulas with vlookups and countuniqueifs to see if by the end of the year, if that account has added any other products.
I’m looking for advice on how to proceed with building this out in Looker. I played around with an existing explore but the thing that trips me up is how to define what is active by the end of a year and summing up the accounts, then making it dynamic so I could choose which year. Hope that makes sense and thank you in advance for the advice!