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.
That won't work. If I have a count of 2 for a discharge reason, it will just become 200%. I need to find a way to write an expression where I divide each individual discharge reason by the total number of discharge reasons