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)
