Trending Graph for the Dashboard of point in time stats

I like the Dashboard feature, but I'm forced to pull my numbers into Excel because there is no way in AHA to tell it to grab the last day of the month for each of my record counts and produce a line graph.

It would be really great to be able to show trending Data based on a Point In Time Snap Shot on a set date the number of records for each condition I set.

For example. I want a line graph that shows the total number of Open Idea, Initatives and Features for the last business day of each month. Over time this will help me share with my leadership the trends.