Combining Different Dates into Looker Table

teejay
Participant I

Hi Guys,

I curious how to go about implementing counts/sums when I have different dates in my data.

Data Structure:

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!

TJ

1 0 367
0 REPLIES 0
Top Labels in this Space
Top Solution Authors