Percent calculation by category

RCPDesign

Hello !
I have a Flat File data source (flatfile.csv).
I want to have the percentage of products for which "Ann? n" > = "Ann?e n-1" by product type and compared to each category

Example for Groupe A category :
I have 27 products :
6 with Type "T1" and only 3 satisfy the condition : "Ann?e n" >= "Ann?e n-1"
==> pourcentage = 3/6% = 50%
9 with Type "T2" and only 4 satisfy the condition : "Ann?e n" >= "Ann?e n-1"
==> pourcentage = 4/9% = 44.44%
12 with Type "T3" and only 9 satisfy the condition : "Ann?e n" >= "Ann?e n-1"
==> pourcentage = 9/12% = 75%
I managed to display the values ??for each category but I was not able to display the desired percentages from each category
in the second time I changed "Value Data" in "labels Series" with "Percentile Value Data" but the result is not good: the calculation is done with respect to all categories and not in relation to each category

Please Help ! How can I have a percent by cat?ogory X-Axis ??

mwilliams

Ok. Take a look at this modified version of your report. I deleted all your computed columns, because you don't need them. Instead, I used a single series, optional grouping, and a filter to do the same. You'll also see there is script in the onFetch of your dataSet to calculate the total number of values in each group (pre filter), which is stored in a global variable named in a way that you can recall it from your chart. Then, in the chart script, you'll see where I replace the current value of the label with the calculated percentage, using the data point value (post filter) and the corresponding value from the variables (pre filter total) we created. Hope this helps. Let me know if you have questions or if I've done something incorrectly.