3 Replies Latest reply on Jun 23, 2011 2:45 PM by Wing Fu

    Local date filter on 2 dashboards, each affecting the other

    Nathaniel Fitzgerald-Hood

      Hi,

       

      I'm struggling a little separating the effects of some quickfilters and filter actions.

       

      The net problem is: I have one sheet used in two separate dashboards. One dashboard has a filter action which includes a specific year.

       

      The second dashboard (using the same sheet) uses a date range quick filter so users can look through the 14 odd years of data. However, the first dashboard leaves the action filter on the sheet and so there's only 1 year of data available - even if the filter shows 14 years in the available date range.

       

      Is there some way of clearing/resetting/limiting the scope of action filters to the dashboard rather than to the sheet (that's how I thought they worked anyway).

       

      None of these are set as global filters because that will start affecting everything else in the workbook which is definitely not what I want.

       

      The only solution I see currently is to duplicate the viz sheet, and that doesn't feel like a nice solution at all.

       

      Thanks,

       

      - Nathaniel