How to create a measure in LookML based on different views/explorers

I have created two views from a table with some implemented measures. It's something basic, illustrated as follows:

 

 

view : view_A {

dimension: Time_A {....}
dimension: Value_A {...}
dimension: code_B {..}
measure: Total_Value_A {
         type: sum .... sql: {$Value_A}
          }
}

AND 

view : view_B {

dimension: Time_B {....}
dimension: Value_B {...}
dimension: code_B {..}
measure: Total_Value_B {
         type: sum .... sql: {$Value_B}
          }
}

 

 

We have two separate explorers based on each view. When we execute the explorers, we get the correct result when using the time dimension for each one of them. Now, it has been requested to implement another metric, which is a combination of the basic ones:

 

 

Total_Value_C = Total_Value_A + Total_Value_B

 

 

Is it possible to achieve something like this in LookML? What could be the right approach, especially considering that each measure is based on a different time dimension?

4 REPLIES 4
Top Labels in this Space
Top Solution Authors