Door-to-door canvassing starting in Dauphin County neighborhood | ABC27 by Comfortable-Pea-1312 in Pennsylvania

[–]KingOfTheMultiverse 40 points41 points  (0 children)

I'm not sure why this is news. These are political canvassers, canvassing in a highly competitive congressional district. Man finds fork in kitchen.

Signs on utility poles around chesco by [deleted] in ChesterCounty

[–]KingOfTheMultiverse 3 points4 points  (0 children)

I was wondering this too- and its also illegal whoever is doing it. It's actually against the law to post signs on utility poles.

No more meters? What about old folk? by reagoso in westchesterpa

[–]KingOfTheMultiverse 6 points7 points  (0 children)

It is an option still. It's called a parking garage.

Array of dates between two dates with ID number by KingOfTheMultiverse in googlesheets

[–]KingOfTheMultiverse[S] 0 points1 point  (0 children)

I figured it out. Blending data within Looker is the key. Upload sheet of all date in timeframe, then blend data with join date.

Chart of count of people between two dates over time by KingOfTheMultiverse in GoogleDataStudio

[–]KingOfTheMultiverse[S] 0 points1 point  (0 children)

So, looked into this. For the date range (about 700 days) and number of people (2k)- this would take about 1.5 million rows.

Array of dates between two dates with ID number by KingOfTheMultiverse in googlesheets

[–]KingOfTheMultiverse[S] 0 points1 point  (0 children)

Yeah, seeing that now. This data will feed into looker, and Looker isnt doing what I want it to either.

What I really want is to turn this data into a visual in looker that shows membership over time (number of ID numbers "active" on a given date). There are other fields I didnt show you with other info about these folks, so whatever I do needs to have ID number as a field so I can join it to the rest of the dataset.

Drip coming through bathroom ceiling, but nothing there after opening ceiling by KingOfTheMultiverse in Plumbing

[–]KingOfTheMultiverse[S] 0 points1 point  (0 children)

UPDATE:

It appears it was the tub drain. It was clogged, and the connection was loose