Sort and Filter a Modelled Data Source


In a modelled data source, how would I:

  1. Sort the entire table by date descending (not just the values in date column)
  2. Filter the entire table by removing rows that has a Recipient Count is less than 10

So far, I can only do these functions on the column alone, not for the entire table. 

Thank you!

1 comment

  • Avatar
    Parker Selman Official comment

    Hi Mica, 

    Thanks for the post! 

    1. You'll need to insert a SORT function into each column in order to sort it in descending order. Specifically, for the date column, your function would looks like:

    SORT ( &Send Date , descending ) 

    Whereas all other columns would be set as: 

    SORT ( &Send Date, descending, &Column Name )

    2. In this case, each column will need to use a SELECT function where you include a condition such that recipient count is less than 10. For example:

    SELECT (&Mailing ID , &Recipient Count >= 10) 

    With all this in mind, the full function for the Mailing ID column, for example, would be:

    SORT( SELECT (&Send Date,  &Recipient Count >= 10) , descending , SELECT (&Mailing ID , &Recipient Count >= 10) )

    I hope this helps! Please let me know if you have any questions around this,


Please sign in to leave a comment.