I curious how to go about implementing counts/sums when I have different dates in my data.
Item | Signed Date | Complete Date
A | 2021-01-01 | 2021-02-01
B | 2021-01-01 | 2021-03-01
C | 2021-01-01 | 2021-04-01
In my end Looker table I’m hoping to get the following:
Date | Number Signed | Number Complete
2021-01-01 | 3 | 1
I can create the two separate measures but I’m getting stuck when trying to combine these with a common date. Any help would be much appreciated!