Filtering a Matrix to only show emails that begin with A to L

[PaulF0901]

Hi,

Hopefully the title says it all but I am displaying two Matrix visuals. These show the count of activity within a product based on the users email address. 

Given there are so many users, I want to split the report out over two visuals, side by side. The left Matrix will show all email addressed from A to L. The Matrix on the right will show all email addresses M to Z. 

I cannot for the life of me figure out how to set a filter for the left hand visual, for example, to only show those emails that start A-L. Might anyone have any idea how I could do this?

Many thanks

[rsbin · Accepted solution]

@PaulF0901 ,

Suggest as follows:
Create a new Calculated Column in your User Table.

Matrix = SWITCH(
     TRUE(),
     LEFT( [Email], 1 ) IN { "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L" }, 1,      
// This obtains the first letter in your email string and assigns first matrix.
            2 ) // else assigns second matrix.

You can use "Left" or "Right" instead of 1 or 2 to define which Matrix you want to assign.

Then use this column in your Filter Pane for each Matrix visual.

This should get you what you are after.

Regards,