Select and attribute from column and sum other column

8171711837 · June 30, 2023, 9:13am

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 · June 30, 2023, 12:53pm

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 · July 1, 2023, 6:08am

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