Customers often want to track stats about the resources\u00a0they’re\u00a0scheduling in DayBack. They want to answer questions like…<\/p>\n
“How many hours do these assignments represent?”<\/p>\n
“What is the total cash value of the\u00a0confirmed bookings this week?”<\/p>\n
[ba-box background=”#98e382″ border=”#4b9b55″ textcolor=”#F7F7F7″]<\/p>\n
This kind of reporting is now built into DayBack. \u00a0Check out the new Calendar Analytics introduced in July of 2018: measure values across your schedule<\/a>.<\/p>\n [\/ba-box]<\/p>\n Stats\u00a0like these\u00a0are easy to add to DayBack and this post describes two different methods for calculating them.<\/p>\n Like many developers, I usually\u00a0think of using relationships first when\u00a0deriving\u00a0date-range stats like these. While that works, I’ll suggest that using find requests is much easier and results in code that requires a lot less maintenance as your requirements change<\/strong>. A description of both approaches follows, along with unlocked example files.<\/p>\n In our examples, we’ll total\u00a0a new field in the events table called “Cash Value” and count the number of events in a\u00a0given week.<\/p>\n This short video shows what we’re trying to accomplish and introduces the two different techniques.<\/p>\nOverview<\/h2>\n