Switching Between Years

Support, Questions and Suggestions for the FM7 Version of CC Calendar.
Posts: 18
Joined: Thu Apr 09, 2009 8:32 am
Location: Missouri
PostPosted: Fri Apr 17, 2009 7:46 am
Is it possible to show on the same layout the number of appointments that month as well as show the number of appointments from the previous year same month.

It would be so cool to be able to calculate this somehow and then show the percent of growth between years.

Is there anyone that can help me write these calculation?

Thanks so much!!!!! :D
Robin
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Fri Apr 17, 2009 12:49 pm
Hi. You'd need a relationship that is true for the same month but the previous year. Then you can use aggregate functions like Sum() or Count() across that relationship to show the comparisons.

Let me know which layout in the calendar you'd like to do this on (and which version of the calendar you have) and I'll post some ideas for the relationship.
John Sindelar
SeedCode

Return to CC Calendar (FM7/8)

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: