Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Percent calculation by category
Migrateduser
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 ??
Find more posts tagged with
Comments
There are no comments yet