Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have got data with various multiple parameters which are termed to be Norm or Expected which needs to be Analyzed.
Attached is a sample of data and I need to count the number of Citizens using the below Parameters.
Question | Norm |
D.O.B | 01/01/1990 - 31/12/2000 |
Family Size | Numeric |
Employment Status | All Except Retired |
Education Level | High School (or) Primary (of) Both |
ID | Alphanumeric |
TransactionType | Credit Card (&) Cash |
Your help and advice is greatly appreciated.
My apologies maybe I expressed my requirements wrongly.
I have that data set in CSV and then I want that data to create a summary table counting number of Citrizens who fall in the criteria of the parameters below
Question | Norm |
D.O.B | 01/01/1990 - 31/12/2000 |
Family Size | Numeric |
Employment Status | All Except Retired |
Education Level | High School (or) Primary (of) Both |
ID | Alphanumeric |
TransactionType | Credit Card (&) Cash |
That for example if the question is D.O.B then it will count the number of citizen who have the response which fall in between 01/01/1990 & 31/12/2000; if the question is Employment Status then it counts all the Citizens with employment status which is not Retired ......... etc.
Like this? May be helps
Seems to be a duplicate thread. Check here:
Is there a way of doing it in script in the event that they are a lot of conditions.
But if we use The same condition in Script, May be you won't get all Question values
thanks