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-
1. Num of DHR is >0
2. Vendor Error is > 5
3. 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?