6 Replies Latest reply: Nov 16, 2012 3:04 PM by Akbar Jiwani RSS

    Writing percent expression

      I'm trying to figure out how to write an expression to show percentage. In my data, I have a field called Discharged Date which gives the date that people have been discharged. I have another field called Discharged Reason that contains a list of reasons why people get discharged. I can create a graph that gives me the count of each discharge reason

       

      Count(if([Discharged Date]=Date,_ConsumerProfileKey)) with my dimension being Discharged Reason.

       

      How do I create a graph that show me these numbers as a percent? I.e. I want to show a graph that shows me what the reason was for dischage by perfect for 2011,or 2012, etc.

       

      Any ideas?