2 Replies Latest reply on Jul 28, 2018 9:13 AM by Naveen B

    Choosing a connecting filter Dimension to enable sheet filter

    Jyothi Nagarajan

      Team,

       

      I have a Dashboard that contains two worksheets.

       

      Worksheet 1:

      Bar chart of number work items in 4 different status that have exceeded SLA

       

      Open ---------------> 4

      Closed ---------->3

      In process --------------------------->10

      Cancelled --> 1

       

      Worksheet 2:

      List of work items

      Work item#      Work item name   Work item status  

       

       

      The worksheet 1 is enabled as Filter.

       

      Action: I click on the bar that says "Closed" on worksheet 1

       

      Expected Behaviour: Only the 3 items that have exceeded SLA should appear on the Worksheet 2

      Actual Behaviour: All the items (more than 3) that have status as Closed appear on Worksheet 2

       

      How would I go about correcting this? If I add Work item# as a "Detail" on Worksheet 1, it works - but the bar chart has boxes for all the work items.