I am using a bar chart and want to calculate the percentage of an item. I am counting the number of occurances a particular field has and want to divide it be the number if Distinct effort numbers. The relationship is 1 to themes (many) to root cause (many). I am using demensions of theme and reporting year in the chart. The formula appears as Count ({$<Rpt_Yr={$(vYear)}>}Theme) / Count (distinct{$<Rpt_Yr={$(vYear)}>}Release_ID). I atttempted to use a variant of Count ({$<Rpt_Yr={$(vYear)}>}Theme) / Count (distinct{$<Rpt_Yr={$(vYear)},Theme=>}Release_ID).
Items to note:
list box for selection is Rpt_Yr and we limit this to only permit one choice, so we pass a parameter from this selection and calculate the second year for the variable vYear. vYear is 2012,2011.
If I use relativity, it would use all the rows and not give me the percentage of distinct projects impacted.