1 Reply Latest reply: Sep 30, 2016 1:56 AM by Tim Driller RSS

    Filter - Select All Update

    Matt Melhus

      Hello -

       

      I have a graph that requires multiple filters to be used; however, when the data is reloaded it messes with one of my bookmarked filters.

       

      Background:

      I needed a filter where the following condition is met:  Ability to identify all Procedures where the Procedure is = A and the Key doesn't have multiple Procedure associated to it.

       

      example:

      Key   Procedure

      1     A

      2     B

      3     A

      3     B

      3     C

      4     A

      4     B

      5     C

      6     A

       

      In this case, I'd like for it to return

       

      Key

      1

      6

       

      To do this I created a Count(DISTINCT [Procedure]) as PPCount in the load script and grouped by Key.  Then I created a filter with the following expression: Aggr(Only({<PPCount = {1}, Procedure = {Screening'}>} Key), Key)

       

      The above expression gives me the correct list of all Keys.  Then I use the select all option and it properly gives the result i'm looking for on the bar graph. However, once I do a data reload and select the bookmark the filter is no longer selecting all Keys.  I have to clear the filter and reselect all for it to populate correctly.

       

      My question:  Is there a way for me to get the filter to properly update after a data load or construct the expression in a different way where a data load wouldn't mess with the bookmarked filter?

       

      Thanks!!