Building Summary Report for List User Field
Hi! I recently added a List User field ("Estimator(s)") to my table where the person adding a new Project record can indicate one or more individuals involved in quoting a project. I would like to cr...
Forum Discussion
Unfortunately since the data you're reporting on is a list-user field you're going to have to report on this in another way. My best recommendation if you're able to swing it - is to try and report via some kind of 'Employees' table where you have a dataset of the actual team members. In that table, there are lots of ways you could do it but the easiest might be a formula query that counts the number of records where the user in question is listed in the list-user field and then you can build your report from that value in the Employees table.
------------------------------
Chayce Duncan
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendIt's in case this is helpful, it is possible to create a dynamic filter field which would list the individual estimators uniquely and only once. You could then cycle through the various dynamic filters for each estimator to see what their chart looks like. But I recognize that could mean a lot of mousing and clicking as you choose different estimators.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thank you, Mark. I think you're right that it would be a bit cumbersome to do it that way since I really need our managers to see the project count by person all at once so they can assess workload.
------------------------------
Sherri Large
------------------------------
