5 Replies Latest reply: Sep 26, 2012 11:22 AM by Mike Dales RSS

    2 counts in one expression - set analysis?

      Hello,

       

      I am looking to use set analysis to count people waiting over 52 weeks from my latest run of data and show this in a text box.

       

      I have got this far

      =Max({<Run_Number = {$(=Max(Run_Number))}>}[PTL Weeks Waited])

      This gets the maximum run number

       

      =count({<[Breach graph wait band]={'52 +'}>}[Breach graph wait band])

      This gets people over 52 weeks

       

      I am looking for a way of putting these two expressions into one to only bring back all patients over 52 weeks for the latest run month only.

       

      I have tried

      =count({<Run_Number = {$(=Max(Run_Number))}>}{<[Breach graph wait band]={'52 +'}>}[Breach graph wait band])

      This counts all patients over 52 weeks but ignores the run number!

       

      This is my first post and any help would be greatly appreciated.

       

      Thanks in advance

       

      Mike