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.
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]
}
}