Forum Discussion

niko18033's avatar
niko18033
Icon for Helper I rankHelper I
6 years ago

Column to toggle between single or multiple categories

I want to create a column that allows me to toggle between emails associated with single or multiple clients (categories). I have a stacked column chart with the following fields.   Axis: 'Email' ...
niko18033's avatar
niko18033
Icon for Helper I rankHelper I
6 years ago

Hi Vivek - Thanks for your quick reply. Below is a sample export of the data. The emails which are essentially duplicates in this table (have a row for more than one client) are the ones I want to keep.

 

Request Count is a measure. = DISTINCTCOUNT(requests)

 

EmailClient Request Count
[email protected]Client A 2
[email protected]Client A 2
[email protected]Client A 3
[email protected]Client B 3
[email protected]Client C 2
[email protected]Client D 9
[email protected]Client C 2
[email protected]Client A 3
[email protected]Client C 3
[email protected]Client A 2
[email protected]Client A 5
[email protected]Client A 2
[email protected]Client A 2
[email protected]Client A 3
[email protected]Client D 2
[email protected]Client D 2
[email protected]Client A 2
[email protected]Client A 2
[email protected]Client B 2
[email protected]Client A 2

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago
[Email Type] = // calculated column
var __email = T[Email] // T is the table
var __howMany =
    countrows(
        filter(
            T,
            T[Email] = __email
        )
    )
return
    If( __howMany > 1, "Multiple", "Single" )

Here is your attribute...