How to add a new row of data with LookML (Community)

View the original community article here

Last tested: Mar 17, 2020
 

For example, starting off with this:

And wanting to add a new row of data:

Use a LookML case, something like so:

when: {
label: “show-rss”
sql: ${event_type} = ‘show-rss’ ;;
}
[more when blocks]
when: {
label: “session”
sql: 1=1 ;;
}
For all of the existing values, you map them back to the same value, then put a fourth when block for session. The idea for the case dimension is just to create a dummy row with no data so that you can use table calcs to put the correct value in each row using functions like offset or index to pick out the specific values