Forum Discussion

heidibb's avatar
heidibb
Icon for Helper IV rankHelper IV
7 years ago

How to filter with overlapping conditions

Hello,

 

I have a data set that has metrics and attributes by assignment:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The data structure is set up so i have a table with assignments, and seperate tables for each grading error column:

Blanks

Late Blanks

Needs Grading

Late Graded

Missing Feedback

Each of these mini tables are joined back to my assignment table.

 

From there, I have slicers set up as so:

 

 

 

 

This looks like a normal filter, but it's actually 5 seperate, each coming from my smaller tables.

 

What I ULTIMATELY want is to click Blanks (for example) to show all rows and all information related to asignments that have "blanks". Then, if I also select Needs Grading (or any combination of additional filters), I want to tack on all other rows that have Needs Grading. Some will have overlap, but some will have only blanks and some will have only needs grading.

 

What I'm getting are rows that have both Blanks AND Needs Grading.

 

Is there a way to do this??

 

Thanks in advance!!

Need Help

3 Replies

    • heidibb's avatar
      heidibb
      Icon for Helper IV rankHelper IV
      7 years ago

      I think I've tried that. So i had my data structured to the following

       

      Assignment Key || Grading Error Type || Qty

      12345 || Blank || 4

      12345 || Missing Feedback || 23

      34567 || Late Graded || 5

      34567 || Missing Feedback || 45

       

      Then I used the "Grading Error Type" in my filter. When I did this, I got the same result as I do now.

       

      If I select "Blank" from the filter, I would get assignment 12345

      If I then select "Missing Feedback" from the filter, I would also get only row 12345 since it meets both conditions.

      What I want to happen is to show 12345 *AND* 34567 since each assignment meets one of the conditions.

       

      Does that make sense??

      • heidibb's avatar
        heidibb
        Icon for Helper IV rankHelper IV
        7 years ago

        Here is a view using my unaggregated data -- I'm seeing all the fields across the top, with all grading error types.

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        If I select in the filter, it is selecting the rows with and without overlap, but it limits my columns:

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        Is there a way to still show the other columns of data for the sections that have Blanks and Late Graded?? So, these ARE the assignments I want, but i would also like to see the other columns (Late Blanks, Missing Feedback, Needs Grading).

         

        I think that's where I'm getting hung up.