2 Replies Latest reply: Mar 9, 2012 11:58 AM by Graham Crooks RSS

    Ignoring a dimension value in an aggregated chart (akin to 'having' clause?)

    Graham Crooks

      To keep the explanation as simple as possible, I’ll describe it thus: I’m counting the number of times patients are admitted to a hospital.Hence:-

       

      Dimension:

       

      =aggr(sum({<set analysis in here>}AdmCounter),PatientID)

       

      Expression:

       

      count({<set analysis in here>}distinct PatientID)

       

      And I get a very nice chart thankyou...

      MultipleAdmitChart.png


      However, for this example, I’m really not interested in the “1” column but I want all the others (akin to a sql “Having Count >=2” clause I guess). How can the “1” column be ignored please?  What do I write? Where do I put it? Any help very much appreciated.