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
Inputs on Grouping and aggregation
Migrateduser
Need few information to do some calculation based on the grouped values.
There are two columns A & B in the database. The column B contains the value of 0 or 1
The report should contains five columns.
1) First column is the grouped value of A.
2) Second column is the aggregated count of B.
3) Third column is the count of B where the values are zero.
4) Fourth column is the count of B where the values are zero.
5) Fifth column should (sum of zero) / aggregated count of B.
Example:
Database:
A B
a 0
a 1
a 0
Report:
Name Total Zero?s One?s Cal
a 3 2 1 0.6 (2/3)
How do to the calculation for the fifth column (Cal).
The second, third and fourth column value are calculated using aggregation.
Any idea or reference would be of great help.
Find more posts tagged with
Comments
There are no comments yet