Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need show the row count in my straight table.
I seen many forums but couldn't found exact result for my requirement.
Date | product_name | product_id | product_desc | A | B | C |
01-01-2021 | ABC | abc_01 | * | 0 | 0 | 0 |
01-01-2021 | XYZ | xyz_01 | * | 0 | 0 | 0 |
01-01-2021 | DFG | dfg_09 | *] | 18 | 0 | 2 |
01-01-2021 | LMK | lmk_09 | * | 12 | 1 | 0 |
01-01-2021 | HGT | hgt_05 | * | 0 | 3 | 4 |
if above table is my dashbaord.my result has to be 3
while counting rows it should not consider ABC & XYZ product because all values are zero. remaining rows has to be considered in count because it contains atleast one KPI value>0.
Please help in getting correct result.
I tried with below conditions
Count(distinct {<A={">0"},B={">0"},C={">0"}>}product_name&product_id&product_desc)
if(A=0 and B=0 and C=0,0,Count(distinct product_name&product_id&product_desc))
Count(distinct aggr(if(A=0 and B=0 and C=0,product_name&product_id&product_desc),product_name,product_id,product_desc))
Try this:
Count(distinct {<A-={0},B-={0},C-={0}>} product_name&product_id&product_desc)