I have data that looks like this:
CustomerID | System | Date | Action |
139049 | Advertisement | 7/4/2020 | Ad from Facebook |
139049 | Catalog | 7/5/2020 | Placed Order |
139049 | Catalog | 7/4/2020 | Stock Check |
139048 | Catalog | 7/3/2020 | Stock Check |
139048 | Catalog | 7/4/2020 | Placed Order |
I'm trying to have a combo chart, dimension is the date and the first measure is the number of unique stock checks, second measure num of customers coming from Facebook ads, and the last measure is a selling rate which is num of placed orders/num of stock checks. However, I can't get the first two measures to not be stacked but grouped next to each other. Is this possible? I've seen it in the documentation example of combo chart but don't see how to do it