I’m trying to build a report that would show growth numbers entered from various countries around the world. I don’t know how much data can be displayed in one graph, but ideally, I’d like to have a timeline based on what months the data is entered throughout the year.
The columns might be as follows:
Country – DateOfRecording – New Groups
First, if I use a date field, is there a way to sum all of the entries from all countries for a year. In other words, I’m wanting a year-over-year cumulative timeline. I obviously have month/day/year in the field. But I do not care about the day or month initially, just the year and want to be able to “group” data based on those values and return sums for all New Groups within the year.
Second, I would like a drill-down graph that displays the same statistics but showing totals within a selected year by month. So again, I suppose I need to isolate and be able to sum the totals based on the month from the date.
Third, I would also be trying to allow filters or drill downs by Country for the same data. This could at least be presented in a chart if not a graph as it is a lot of information from over 100 countries. Perhaps still a selector for graph that allows looking at one country at a time.
Ideas on where to start? I’m even developing the tool for gathering the data so I have a lot of flexibility on how to capture the types of data needed.