Question

Combining Different Dates into Looker Table

  • 1 November 2021
  • 0 replies
  • 19 views

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

 


0 replies

Be the first to reply!

Reply