ContributionsMost RecentMost LikesSolutionsMilestone SummaryThis may be something solved with non-native solutions or it could be my Friday brain, but I can't figure this one out. I have a Projects table that has four different duration fields (PDR, DDR, CDR, FDR). Based on the duration value, the color of the circle changes (this i know how to do). I would like to summarize it so that each row is a Project record and the columns are the months/years. Mockup below: Any ideas? Thanks in advance! William ------------------------------ William C ------------------------------ Re: Combine Summary ReportsYes, there is a "Start Date" that is a data entry field ------------------------------ William C ------------------------------ Re: Combine Summary ReportsThanks, Mark! I did everything as instructed for the first table. When i tried to add summary fields to the first relationship i received the following: We are sorry -- at this time, you cannot create a summary field using a relationship where the reference field is this type of formula field. Please visit our limits page (https://lamresearch.quickbase.com/db/main?act=dohelp&page=quickbase_limits) or contact Care for more information. Any idea how to get around this? Best, William ------------------------------ William C ------------------------------ Combine Summary ReportsI have two tables: Employee Leave and Active Directory. Employee Leave records have a Shift Type and Date. Active Directory records also have a Shift Type. The Active Directory can have many Employee Leave records. I want to summarize the number of Missed Shifts and Available Shifts in one summary report, grouped by week and Shift Type. I also need to add calculated columns like Total Missed %, and Missed % by Shift Type. This doesn't seem difficult in theory but I can't seem to combine the two. Attached is an excel version of what I'm trying to create. Thanks in advance! William ------------------------------ William C ------------------------------