Forum Discussion

thmonte's avatar
thmonte
Icon for Helper IV rankHelper IV
8 years ago

Create Visual/Table based on searching unique IDs and other filters in a table.

I'd like to have one date slicer to check the following scenario

  1. Filter 1 - Search The Previous Day Selected for all Rows that match shift = "1600-0000"
  2. Filter 2 - Search Day Selected for all rows that match shift = "0600-1400" || "0700-1500" || "0800-1600" and Id = Id that is present in Filter 1
  3. Return All Rows that have matching Ids in both Filter 1 and Filter 2

 

dateIdshift
1/28/2018100190800-1600
1/28/2018101501600-0000
1/28/2018102520800-1600
1/28/2018102740000-0800
1/28/2018107460800-1600
1/28/2018108021600-0000
1/28/2018110900000-0800
1/28/2018110950800-1600
1/28/2018115451600-0000
1/28/2018113610600-1400
1/29/2018113670000-0800
1/29/2018114481500-2300
1/29/2018115100000-0800
1/29/2018101500600-1400
1/29/2018108020700-1500
1/29/2018116800000-0800
1/29/2018115450800-1600
1/29/2018116940000-0800

 

 

I'd like to return the following

 

dateIdshift
1/28/2018101501600-0000
1/29/2018101500600-1400
1/28/2018108021600-0000
1/29/2018108020700-1500
1/28/2018115451600-0000
1/29/2018115450800-1600

 

Need Help

4 Replies

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Icon for Solution Sage rankSolution Sage
    8 years ago

    thmonte

     

    I’m not quite understand your requirement, there’re several questions:

     

    1. What are the values in your slicer? Text values like “Previous Day”,  “Day” or specific date values like ‘2018-01-29’, ’2018-01-30’? If it is specific date values, then what does “Day” mean in your second filter?
    2. In your second filter: Search Day Selected for all rows that match a value(s) in column B AND match unique values in First Filter. When select Day, you want to get all the rows that match a value(s) in column B. What is this a value(s)? And what does match unique values in First Filter means?
    3. The shift value is like a range (1600-0000). Then how to decide for example Shift = 1600 or Shift = 0600?

     

    Please kindly elaborate you requirement by sharing us more detailed logic.

     

    Thanks,
    Xi Jin.

    • thmonte's avatar
      thmonte
      Icon for Helper IV rankHelper IV
      8 years ago

      v-xjiin-msft

       

      1. I believe to use the date slicer I'll need a new row generated based on all of the logic with a single date.  All of the dates in my table are actual dates and not text.

      2. I guess my logic explanation is pretty bad now that I am re-reading it.

       

      Hopefully this provides more clarification:

       

      I want to have a Date slicer with a single day picker.  What I need to do is based on the day selected check the previous day for all rows that have a shift = "1600-0000" and compare that against all rows that have "0600-1400" OR "0700-1500" OR "0800-1600".  On top of all that I want to show rows that only have an ID in each of those days so for example:

       

      if I selected 1/2/2018 on my date slicer

      then

      if ID is present on 1/1/2018 with a shift of "1600-0000"

      AND

      ID is present on 1/2/2018 with a shift of "0600-1400" OR "0700-1500" OR "0800-1600"

       

      then return those rows that match in the table