Case Statement

New to Looker and need some help.  I have the following query which works fine.  What I’m trying to do is add a case statement.. such as below so I can view 2 queries.  I’ve tried a join but get the error that Druid does not support the Join.

 case when  Field key   = 'ADD_REQUESTS' then  sum("FIELD_VALUE")/2 AS  else 0 end as "Add_BHCA",
  case when  Field key   = 'Total_RTP_Term'    then  sum("FIELD_VALUE")/2 AS  else 0 end as "RTP_BHCA"
 

view: OSPF_Area_1_Add_BHCA {
  derived_table: {
    sql: SELECT TIME_FLOOR("__time", 'PT1H') AS "__time",
      sum("FIELD_VALUE")/2 AS "Add_BHCA"
FROM "druid"."edgeai-mrfp"
WHERE "NODE_ID" LIKE '%MRFP-OSPF1%'
  AND "FEED_NAME" LIKE 'MRFPVmgGeneralIntStats'
  AND "FIELD_KEY" = 'ADD_REQUESTS'
  AND "FIELD_VALUE" > '0'
GROUP BY TIME_FLOOR("__time", 'PT1H')
ORDER BY "Add_BHCA" DESC
LIMIT 100000
 ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }

  dimension_group: __time {
    type: time
    sql: ${TABLE}."__time" ;;
  }

  dimension: Add_BHCA {
    type: number
    sql: ${TABLE}."Add_BHCA" ;;
  }

  set: detail {
    fields: [__time_time, Add_BHCA]
  }
}

0 0 131
0 REPLIES 0
Top Labels in this Space
Top Solution Authors