How to add a new row of data with LookML

Knowledge Drop

Last tested: Mar 17, 2020
 

For example, starting off with this: Screen Shot 2020-03-17 at 12.47.38 PM.png

And wanting to add a new row of data:
Screen Shot 2020-03-17 at 12.47.56 PM.png

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

This content is subject to limited support.                

Version history
Last update:
‎05-07-2021 09:48 AM
Updated by: