Forum Discussion

murphm6's avatar
murphm6
Helper II
3 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 columns which are acting as flags (simple 1,0). How can I get a distinct count of order numbers with any sort of flag associated with it? There are some order numbers which have multiple flags, but I would only want to count those once. Here's a snapshot of the data (the three flag columns are highlighted):

 

 

Need Help
  • Cado_one's avatar
    Cado_one
    3 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

1 Reply

  • Cado_one's avatar
    Cado_one
    Resolver III
    3 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