Using COUNT Function to Count if a row has a value from multiple different columns

kp2 — Wed, 01 Mar 2023 11:25:16 GMT

Hi there,

Trying to run a COUNT statement to take a running total of any rows that contain a value in two different columns, left an example below

Ideally the total would be 4 and would be used for a KPI chart, I can create the code for one column but not more

Any help would be greatly appreciated

Re: Using COUNT Function to Count if a row has a value from multiple different columns

BenjaminT — Thu, 02 Mar 2023 14:42:22 GMT

Could you try something like this at the row-level:

aggr(count(Col1)+count(Col2)+count(Col3), Col1, Col2, Col3)

For the KPI, you could then just wrap this inside a sum().

(This assumes your blank values are NULLs)