Select and attribute from column and sum other column

[8171711837]

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

[Vignesh_Kannan]

Create a calculated field as shown below,

Calc1

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

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

[8171711837]

@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.