RyanFarrington1
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Count of Tasks Started within a week to statically appear on another table's record
Okay, now 8/18 is showing up as 60 tasks. Current week is still 0. I guess so far, so good! I'll continue making some other summary fields. Thanks for your perspective, Mark. ------------------------------ Ryan Farrington Graphic designer, project manager, copywriter, engraver, internal Quick Base developer rfarrington@experiencepinpoint.com ------------------------------Re: Count of Tasks Started within a week to statically appear on another table's record
Thanks, that makes sense. I set this up to count the number of Signage Production Tasks completed in a week. Out of 7 records, the data summarizes correctly on 5 of them. On the current week and two weeks ago, the summary is 0. Now let's click on the "0" summary for week 8-18-2019. The resulting report shows 60 records! Customizing the report, we can see the parameters. It's summarizing Tasks whose Scorecard Period Based on Date Task Complete is equal to TODAY instead of the proper date of 8/18. This date filter is true on drilldowns for any week, even the ones that correctly summarize the data (go figure). Why do 8/18 and 9/1 not show the data properly? ------------------------------ Ryan Farrington Graphic designer, project manager, copywriter, engraver, internal Quick Base developer rfarrington@experiencepinpoint.com ------------------------------Re: Count of Tasks Started within a week to statically appear on another table's record
Thanks, but the problem I'm having is getting those counts summarized in one field. I can't get it to summarize all the tasks whose FirstDayOfWeek([Date Completed]) = the Scorecard Week Date. The result I get when trying to do that only counts tasks whose FirstDayOfWeek([Date Completed]) = today's Date, which of course isn't going to work. The weird thing is that for Scorecard records that are over 2 weeks old, the data works OK, but not for the latest two Scorecard records. So the summary for Week 8/18/2019 is an accurate count, but for 8/25 and 8/31 return zero. That's if I set up the Tasks as children of the Week. ------Original Message------ Automations to the rescue. This used to be difficult to do later play or impossible but now it's super easy as 1,2,3 Step 1. Make a saved table to table import to copy from your source table which has your summary records that you want to snapshot into a static table Step 2. Set up an automation to run that saved import say every Sunday. Step 3. Y'ur done! Now I'm not actually sure if you have a source record to use to copy into your static table but you should be able to create a record in day a new single record table which will summarize the number of open tasks or the number of test started or the number of test completed, whatever kind of stats you want onto that single record. post back if you have trouble getting your various counts summarized onto a record. ------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com markshnier2@gmail.com ------------------------------Count of Tasks Started within a week to statically appear on another table's record
My company is trying to gather metrics on our projects in weekly records and save them in our Scorecard table. Scorecard records are called Weeks. We can create reports to produce the data and manually enter them into a Week. But of course we don't want to do it manually. I can't seem to get the right information to summarize in the Scorecard. (Additionally: we want this data to go out in an e-mail, so we can't just have a Scorecard Week filled with summary reports.) The short question is, how do you get Report data (which is essentially a snapshot in time) to get logged into a table record? More specifics: for one Week, we want to see how many tasks were started and how many were completed. So, one Week has many Tasks. But I think each task also has many Weeks: 1 for week started and 1 for week completed. I set up two fields in the Task to return the FirstDayOfWeek the task was started and that it was completed. These, then, correspond to Scorecard Week dates. But I cannot get the Scorecard Weeks to summarize all tasks started during the Week (based on that start-date-to-week field). Tasks are currently set up as children of Weeks. I'm probably misunderstanding something fundamental about Relationships but can't wrap my head around it. Any help is greatly appreciated! ------------------------------ Ryan Farrington Graphic designer, project manager, copywriter, engraver, internal Quick Base developer rfarrington@experiencepinpoint.com ------------------------------
