I think that analytic snapshots have some value, but they seem to be difficult to use in a practical way for saving snapshots of summary data. Do you have any ideas of how to do this better than what I have tried so far?
I need to report on the trend of sales values per month over time. This is a great use for Analytic Snapshots.
The Analytic Snapshot should store the Month, the Year, the Value of sales and the quantity of products sold.
I set up my report to show me all sales made in the last month, and then set the analytic snapshot to run on the first day of each month.
My report needs to be grouped so it will only save the totals for each month into the Target Object for the Analytic Snapshot.
However, how do I create a Year or Month field in the summary data in the report? Here are the options: * Group by Month - the summary label shows as "January 2013" - when that gets into the Target Object it is just text and it is not sortable by month. * Group by a formula field giving me the month value or the year value - that would be great except that you have to summarise that data, so even if you choose max or min you get "max 1" for January or "max 2013" for 2013 - these would have to go into a text field in the Target Object.
So, right now, it looks like I am going to have to do a formula field on the Target object to do some detailed string manipulation to create the date (1/1/2013) out of "January 2013" to then show my trend line in my report based on the Target Object.
I really hope I am missing something really simple here, so if you have any ideas, I would be most grateful.