1 Reply Latest reply: Apr 28, 2017 8:36 AM by Peter Rieper RSS

    Date filters to work only when selected - not when other date related to date is selected

    Karen Lou

      I have two tables of data that are essentially unrelated.  Both tables have a date field.  For ease of explanation, let's say table 1 has a date field and a sales field, table 2 has a date field and a score field.  If I filter on a specific sales amount, my charts will only show me scores on the dates that have that specific sales amount.  I want to still be able to see all scores on all dates.  Likewise, if I filter on a specific score, my charts will only show me sales on the dates that have that specific score.  I want to still be able to see all sales on all dates.  However, when filtering on a specific date, I want to only see sales and scores for that date.  Essentially, I want the date filters to work one day, but not the other.  Is this possible?