Question

How to aggregate and count the occurrence of TRUE and FALSE?. I want count of those whose correct and wrong. Can someone help?

Answer 1

Hi, you can do any of below ways.

• You can count the true/ false by filtering them and then make them a set and perform aggregation (CNT ()) on the data .
• Create a calculated field and then apply aggregation on them.

         

Right click and drag the created field in the text shelf, then click on CNT() box to display number of true and false.

         

Hope this helps you.