Hi Guys, I am using SAS Visual Analytics 7.3 and I still a beginner. I work at Electronic Arts and I wouls like to share a problem that I am facing. I am trying to create a stacked bar chart which is normalized to 100%. Lets say my category is: Date Measure is: Number of Events Group: Result. So essentially I would like to see for each day, the different types of results stacked on top of each other normalized to 100%. So far I have been able to do it. But the Problem is: I want to add a data tool tip that would give me the sum of a bar not just value of one piece in the stacked bar of each day. If i try to create an aggregated measure where I sum by group the number of events, it still gives the value of one piece which is not what i want. And if I try aggregate measure where I sum by all, then it gives me the sum of all the bars not one bar. Please help? EDIT: My data looks like as follows: I have a field called result, and it has several different values such as a,b,c,d. There is a count of these events for each date. So i would like to see how the distribution of these events change over time using a stacked bar chart and i would like to normalize it 100%. For further reference a sample excel sheet is attached.
... View more