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
Calculate Percentage in CrossTab
Migrateduser
Hi ,
I have a table with the following rows.
+
+
+
+
| date | sessionParameter | count |
+
+
+
+
| 2012-06-17 | SessionCount | 1245 |
| 2012-06-16 | SessionCount | 1245 |
| 2012-06-15 | SessionCount | 1245 |
| 2012-06-14 | SessionCount | 1245 |
| 2012-06-13 | SessionCount | 1245 |
| 2012-06-19 | EscalationCount | 123 |
| 2012-06-18 | EscalationCount | 234 |
| 2012-06-17 | EscalationCount | 245 |
| 2012-06-16 | EscalationCount | 345 |
| 2012-06-15 | EscalationCount | 178 |
+
+
+
+
I am trying to Produce a Crosstab report as shown below..
06/13/12 06/14/12 06/15/12 06/16/12 06/17/12
Resolution Rate 20.00% 15.00% 20.00% 18.00% 20.00%
Where Resoultion rate is calculated as follows -(EscalationCount/sessioncount) * 100
Can someone help me how can i get this done ?
Find more posts tagged with
Comments
There are no comments yet