My db is tracking year over year results, say of widgets sold daily. Each widget sale makes a record with a date and a dollar value. In analyzing my data, I can easily find a specific time frame (like all of 2014) and see the total Widget sales per month or by color, or whatever. What I can't do, and want to, is to compare the results of 2014 to 2015 .... compare search results of different time frames. Anyone know how to do this?
I was thinking of searching says 2014 and using "Set Variable 1" of search one and "Set Variable 2" for search two and then maybe placing the results of "Set Variable 1" and "Set Variable 2" in new fields of a new record that can then compare ... am I on the right track or is there a better way?