Crosstab report with data data
I have two tables (students, courses) which are related in an associative table (student courses). I have a unique compound key on the associative table, so I know there is only one occurrence for e...
Forum Discussion
Cathy,
You have the data now the trick is to turn it into information. Unfortunately I know of no way to make a summary and cross tab display what you want in Quick Base.
You mentioned that the Summary field to the Student table is giving you the result but requires Summarizing every Course. I have clients with hundreds of fields in their tables. Managing the forms for thoughtful workflows can be a challenge, but having 55 Summary fields will not hurt your application.
If that gets you the report you need then it is a pretty painless method compared to having to take your data externally to do visualizations. If your reporting needs get even more complex, namely your Student Courses table will no longer have unique combinations, then using something like Tableau or Power BI becomes your next option. They are pure reporting tools and will not manage the day to day workflows like Quick Base.
If you want to discuss those options, please reach out.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
You have the data now the trick is to turn it into information. Unfortunately I know of no way to make a summary and cross tab display what you want in Quick Base.
You mentioned that the Summary field to the Student table is giving you the result but requires Summarizing every Course. I have clients with hundreds of fields in their tables. Managing the forms for thoughtful workflows can be a challenge, but having 55 Summary fields will not hurt your application.
If that gets you the report you need then it is a pretty painless method compared to having to take your data externally to do visualizations. If your reporting needs get even more complex, namely your Student Courses table will no longer have unique combinations, then using something like Tableau or Power BI becomes your next option. They are pure reporting tools and will not manage the day to day workflows like Quick Base.
If you want to discuss those options, please reach out.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------