Forum Discussion

murphm6's avatar
murphm6
Icon for Helper II rankHelper II
4 years ago
Solved

Count distinct rows across multiple columns

Hey everyone,   Can anyone help with this?    I'm analyzing some invoices and have created a series of flags to highlight invoices which could have potential issues. There are 3 calculated column...
Need Help
  • Cado_one's avatar
    Cado_one
    4 years ago

    Hi murphm6 

     

    You can add one more calculated column

     

    IsFlagged =
IF(
[70%Flag] = 1 || [HasGreaterThanOcean] = 1 || [Multiple Ocean] = 1,
"IsFlagged"
)

     

    Then in your visual use a distinct count on this new column 🙂

     

    Have a good day,

    Cado

Cado_one's avatar
Cado_one
Icon for Resolver III rankResolver III
4 years ago

Hi murphm6 

 

You can add one more calculated column

 

IsFlagged =
IF(
[70%Flag] = 1 || [HasGreaterThanOcean] = 1 || [Multiple Ocean] = 1,
"IsFlagged"
)

 

Then in your visual use a distinct count on this new column 🙂

 

Have a good day,

Cado