Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Laying Out Complex Summaries


This topic is 6932 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

I have a database with three main tables: Reports; Projects: Evaluations. In each report, we evaluate the progress of about 20 projects. Each project is evaluated according to 5 criteria (relevance, efficiency, effectiveness, impact, and sustainability). Each project can be assigned any one of six possible ratings for each of these criteria (-2, -1, 0, +1, +2). For each report, I want to summarise the number and/or value of projects by criterion and by rating. This is a simple matter if I take one criterion at a time. But if I try to summarise all criteria at the same time they are "nested". Is there any way to summarise all criteria at the same time and at the same level so I would get the number of projects rated -2, -1, 0, +1, +2 for relevance, and then listed below this the number of projects rated -2, -1, 0, +1, +2 for efficiency at the same level as relevance, not as a subset of relevance?

This topic is 6932 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.