0 Replies Latest reply: Sep 22, 2014 1:38 PM by Ben Paulson RSS

    Label for ranking in text box

      Hello Community,

      I'm wondering how to make the below equation on my dashboard just a simple integer.  Right now, it displays the HouseHold.ReportingTeam and then the integer, like "Example Team3" [sic].  The point of the text box is to rank the HouseHold.ReportingTeams, if that matters.  However, I've already got a header on top of the text box, so I don't need a repeat of the "Example Team" part.  How do I get rid of it without changing the ranking?

       

      Thanks!

       

       

      Ben

       

       

      --------------

       

       

       

      Num(rank(Count({ <HouseHold.InceptionDateFlag={1}, HouseHoldIntroHeld.IsCanceled={0}, HouseHoldIntroHeld.IsNoShow={0} > } DISTINCT HouseHoldIntroHeld.WEGAccountNumber))

      /

      Num(Count({ <HouseHoldIntroHeld.IsCanceled={0},HouseHoldIntroHeld.IsNoShow={0}> } DISTINCT HouseHoldIntroHeld.WEGAccountNumber))*100,

      HouseHold.ReportingTeam)