0 Replies Latest reply on Nov 29, 2018 8:39 AM by jon rios

    Date Filter, Relevant vs All Values

    jon rios

      my workbook connects to 8 different datasources, has 120 sheets and 10 dashboards....

       

      I have a date field (has 10 quarters of data on primary datasource) that i also use on Columns and as a filter is assigned to 75 different sheets as a global filter and used in 8 dashboards as a filter drop-down....

       

      when i select "Only Relevant Dates" it shows all values, 2061 Q1 thru 2018 Q2, a total of 10 values.  If i select "Only values in Database", it only shows 3 values...  can anyone explain??

       

      does it take into account the values that ALL datasources have in common and only show the 3 common values among all datasources???

       

      thanks