Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
Please, could someone help me with this scripting:
I i put this expresions:
1) Number
( distinct CSQUEST_ID)
2)%:
({<[Question Desc]=>} distinct CSQUEST_ID)/count({<[Question Desc]=>}total distinct CSQUEST_ID)
I get this table:
YEAR_MONTH | 2013/06 | 2013/06 | 2013/07 | 2013/07 |
Age Range | Number | % | Number | % |
18-24 | 87 | 1,7% | 142 | 2,8% |
25-34 | 393 | 7,7% | 627 | 12,2% |
35-44 | 377 | 7,3% | 779 | 15,2% |
45-54 | 405 | 7,9% | 878 | 17,1% |
55-64 | 429 | 8,4% | 478 | 9,3% |
65-74 | 269 | 5,2% | 202 | 3,9% |
75 or more | 37 | 0,7% | 31 | 0,6% |
The issue is that what i want to get is this table: ( A percentage of the month)
YEAR_MONTH | 2013/06 | 2013/06 | 2013/07 | 2013/07 |
Age Range | Number | % | Number | % |
18-24 | 87 | 4,4% | 142 | 4,5% |
25-34 | 393 | 19,7% | 627 | 20,0% |
35-44 | 377 | 18,9% | 779 | 24,8% |
45-54 | 405 | 20,3% | 878 | 28,0% |
55-64 | 429 | 21,5% | 478 | 15,2% |
65-74 | 269 | 13,5% | 202 | 6,4% |
75 or more | 37 | 1,9% | 31 | 1,0% |
Is this possible?? Thanks a lot!
Belén
Try this.
({<[Question Desc]=>} distinct CSQUEST_ID)/count({<[Question Desc]=>}total <YEAR_MONTH> distinct CSQUEST_ID)
Try this.
({<[Question Desc]=>} distinct CSQUEST_ID)/count({<[Question Desc]=>}total <YEAR_MONTH> distinct CSQUEST_ID)
Try with total <Month> in the second part of your expression
Fabrice
Thanks a lot! it Works!
You are so nice!
Excellent
Tag Nilesh's answer as correct then
Fabrice
Please mark the answer as correct.
-Nilesh
Thanks Fabrice.
-Nilesh