Forum Discussion

reast's avatar
reast
Helper II
9 years ago
Solved

Filter for notes on same day by same provider

As a double check, we are wanting a dashboard to show notes when the same provider wrote two notes on the same day since it could be an accidental duplicate. I don't see how I can set it up to filter...
Need Help
  • Interkoubess's avatar
    Interkoubess
    9 years ago

    Hi reast,

     

    I have created a measure like this ( My Table AutrData, I added 2 more providers for tests) :

    Test = IF(COUNTX(AutrData,AutrData[    Date     ])> 1 ,COUNTX(AutrData,AutrData[    Date     ]),BLANK()).

    Then with a matrix (See image below) I have this report ( does not show the blank ones).

    Hope it helps ...

reast's avatar
reast
Helper II
9 years ago

The idea is a provider would select her name from a filter and then in the table below would see the notes that she'd written when there was more than 1 for any given day. The data is something like below, but I want to filter out rows 3 and 6 because there's only one note on those days. Thanks!

 

Provider          Date     

Mary                 1-1-17

Mary               1-1-17

Mary                2-2-17

Mary                 3-3-17

Mary                 3-3-17

Mary                4-4-17

Interkoubess's avatar
Interkoubess
Solution Sage
9 years ago

Hi reast,

 

I have created a measure like this ( My Table AutrData, I added 2 more providers for tests) :

Test = IF(COUNTX(AutrData,AutrData[    Date     ])> 1 ,COUNTX(AutrData,AutrData[    Date     ]),BLANK()).

Then with a matrix (See image below) I have this report ( does not show the blank ones).

Hope it helps ...

  • reast's avatar
    reast
    Helper II
    9 years ago

    Exactly what I needed. Thank you so much!!