NEW — you can now export chart data to CSV or Excel–or display the underlying data right on the page!

(see blue highlighted area in the screen shot)

Revenue by Category, with options to export

In case you haven’t seen our application, let’s list the available charts:

• Families by year
  • Joined by year (this is the number of households who joined the congregation, year by year)
  • Joined minus resigned by year (which gives you a net membership count, by year)
• Families by Zip (bar graph, showing number of households by zip, with hyperlinks to those households).
• Pledges by Year (stacked bar graph, interactively showing pledged and paid, by year)
• Revenue by Category (pictured above)
• Pledged-Paid Gap (line graph, going back several years, showing the cumulative difference between pledged amounts and paid amounts).

For each chart, there is a little symbol toward the upper right that lets you export the chart to PDF, JPG, PNG, or just print it directly.

With this change, that same symbol allows you to export the data that goes into making the chart, into a spreadsheet-compatible format.

We have three improvements in which you might be interested, with a six-minute video that runs through all three:

Queries with ‘NOT’; bulk status changes.

• Bulk change of family status:  when you run a family/household query, you will now see a button on the bottom left of the screen.  That button enables you to change the status of any families that you check.  For example, you might query for all families with attribute “moved away.”  From there, in one step, you could change all of those families to a status of “Inactive.”
• On family/household queries, you can now pull lists of families who do not have a certain attribute.  There is one example in the video above.  Here’s another example–suppose you want to do a paper mailing, appealing to raise funds for a new roof.  You maintain an attribute called “Founding Families,” to whom you might make a personal appeal.  You would want to exclude from that query the Founding Families, so as not to send them the general appeal communication.
• Likewise on individual member queries. There is a good example in the video, namely pulling a list of ladies in your congregation who are not in the Sisterhood.