In looker while creating a table which shows created month, vendor name , num of dhr, num of ncmr and vendor error %, in this table when we try to show the total that shows as null.
This visual has following filter applied-
-
Num of DHR is >0
-
Vendor Error is > 5
-
Part Products is Implants
Num of DHR, Num of NCMR and Vendor Error are measures.
measure: Num_of_DHR{
type: count_distinct
sql: ${dhr_id};;
drill_fields: [dhr_id]
}
measure: Num_of_NCMR {
type: count_distinct
sql: CASE WHEN ${ncmr_id} != " " THEN ${ncmr_id} END ;;
drill_fields: [ncmr_id]
}
measure: vendor_Error{
type: number
sql: If( ${Num_of_DHR}=0,0,${Error_Rate}) ;;
value_format: “0.00%”
}
On further analysis I could see that if I change Vendor Error is > 5 to Vendor Error is > 3 then the total appears but when i select it back as > 4 or anything more than 4 then it shows total as null.
Can someone please tell how to resolve this?