Forum Discussion

3Jk33f3's avatar
3Jk33f3
Icon for Helper I rankHelper I
2 years ago
Solved

Need Measure to show behavior AFTER date from column

I've searched the forum and haven't come across close to what I need. We have a program internally that insepcts customer activity. There were some customers that received a letter 6 months into the...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Yes, it makes sense, but the inspector seemingly only found one bin. Did he/she ignore the other one? What would the close ratio be?

3Jk33f3's avatar
3Jk33f3
Icon for Helper I rankHelper I
2 years ago

Sorry for the confusion. It is possible the inspector made an error when inputting the data. I've had to modify the Powerapp to only take in the number of lid bins that business owns to avoid that error from the inspector.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    No need to apologize - i just want to understand what rules to apply in such scenarios.  Should the non-inspected container count as open or closed?

    • 3Jk33f3's avatar
      3Jk33f3
      Icon for Helper I rankHelper I
      2 years ago

      If it not marked at closed, it would be assumed to be open. 

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        Your sample data is inconclusive. None of the business that received the 6 month letter have been inspected after that.