How to aggregate this table?

Question

I have this table:

Column C counts 1 when A = B and all these 3 are custom metrics.

Is there a way to make an aggregate view with only columns D, E and C? If we make a pivot or modify col C metric with "SUM" all the values are the same for each D or E value

Sumanth V -Oracle · Accepted Answer

@Stefano_Mazzocca -

Instead of SUM( C) , use COUNT(A) FILTER (WHERE A = B) to ensure proper aggregation.

This ensures that C is counted only when A=B.

Hope this helps!