Source:
- I have a Google Sheet with the following columns/fields: CTPID; Result Code; Contact Date.
- It is a list of 7017 rows, with each contact having a result code.
- There are 3385 unique contacts (CTPID).
- Some have 1 result code, others may have up to 5.
- There are 19 different result codes.
Looker challenge:
-
I want to create a table showing the current status of the database.
-
Specifically, I need to find the most recent result code for each CTPID.
-
This will result in a table:
-
with 19 rows (the result codes)
-
and the sum of each result code
-
based on the latest contact.
-
The total should be 3385.
I have to solve the issue in Looker as the data in the google sheets change daily.
Can you please help me with this?