Select and attribute from column and sum other column

I want to calculate NO order in hours how to calculate from this.

select sum(duration) from table where oeecategory=‘NO’.
Like this query, how to implement this in calculated field

Create a calculated field as shown below,


ifelse(oeecategory=‘NO’, duration ,0)

After this you can do SUM(Calc1) to get required output

1 Like

@Vignesh_Kannan I want to build dashboard for OEE, Avaialbility and Throughput.
Could you please help me to do calculation for this. I am sharing you screenshot of all te tables. Please help me as i am new to use this tool.