Jeff Volkhammer
asked on
Database Metrics
Greetings!
I'm wondering if it's possible to build views (or forms) that can count forms and field values and display them in such a way that they can be used for reporting.
For a simple example:
My database is a repository for questions to be asked to software developers.
The fields in the form include Topic, Status (open/assigned/closed),
I would like a view or form that can display counts of saved forms and might look like this:
Question Topics Open Assigned Closed Total
Billing 3 2 11 16
Print 2 2 8 12
Web Features 5 2 18 25
Testing 3 3 5 11
Hardware 2 2 1 5
Can this be done? If so, where can I find documentation in online help, etc. on how to do this?
Thanks!
I'm wondering if it's possible to build views (or forms) that can count forms and field values and display them in such a way that they can be used for reporting.
For a simple example:
My database is a repository for questions to be asked to software developers.
The fields in the form include Topic, Status (open/assigned/closed),
I would like a view or form that can display counts of saved forms and might look like this:
Question Topics Open Assigned Closed Total
Billing 3 2 11 16
Print 2 2 8 12
Web Features 5 2 18 25
Testing 3 3 5 11
Hardware 2 2 1 5
Can this be done? If so, where can I find documentation in online help, etc. on how to do this?
Thanks!
ASKER
I think this is the right track. A couple questions...
Is it possible to set the view so that it cannot be expanded?
How do I get the totals column as shown in my example all the way to the right to work?
Is it possible to set the view so that it cannot be expanded?
How do I get the totals column as shown in my example all the way to the right to work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Make the first view column use field TOPIC and in that columns sort options, set it to CATGEORIZE.
Make the second columns based on formula @If(TOPIC="Open"; 1; 0) and on the sort tab, set it to not sort, but on the bottom of the tab turn on column totals
Repeat for three additional columns, but changing TOPIC="Open" to Topic="Assigned" etc.
Save the view, take a look at it. When collapsed, it should give you what you want.
All this works so long as you ask only one question i each document.