Hey folks, I’m still fairly new to Looker and I’m trying to format some data in a way that I can easily produce graphs, etc…
I have tried various versions of pivots, pivot functions, custom SQL… and I still can’t get what I’m trying to do. I’m thinking that this is likely a common problem but I’m getting dry on my research/attempts.
Here’s a simple example:
what I have:
| id | name | field name | datetime_val | num_val | string_val |
| 1234 | abc | title | | | the thing |
| 1234 | abc | start | 23151346 | | |
| 1234 | abc | end | 3464363 | | |
| 1234 | abc | total | | 765 | |
| 1234 | abc | description | | | some description of the thing |
What I’m trying to produce
| id | name | title | start | end | total | description |
| 1234 | abc | the thing | 23151346 | 3464363 | 765 | some description of the thing |
LinkedIn
Twitter
