Count ID with below() values

[AlexWest]

Hi, guys!

I have a table chart

ID| Flag1 (from script)| Flag2 (from script)| below(Flag1) | below(Flag2)

23 | - | - | 1 | 1

23 | 1| 1| - | -

Is there any way to Count these clients who have belowed Flags in KPI Chart? Because by default BELOW func can't be used in COUNT(IF()) construction?

Thanks!

[Gabbar]

try creating those belowed columns in script only, 
because below function in Charts only worlks where one can have data in tabular format, it doesnt work in KPIs.

[AlexWest]

Thanks for advice. Can you help me with a function in script?

[Gabbar]

I can but that would require me knowing all fields of table and some of those values as an example,
i wont be able to make the script from above data that will work perfectly.

2 Id with 3 rows each will help a lot.

[Aditya_Chitale]

@AlexWest ,

Firstly, I would suggest you to replace '-' with '0' in your data. Once done with that, you can use below expression to find the count:

count(if(tab3=Aggr(below(tab1),name) ,1 , null()))

Regards,

Aditya