ColoradoMatt
MIS
I am trying to build a graph that has a few different parts.
1. Grab dates from a table.
2. Categorize by Month.
3. Count number of entries for that Month.
4. Graph the number of entries for that Month.
Sounds easy, but the trick is that there are three categories that I want to graph. All of them have to be graphed according to the ruleset above on the same graph.
If that's not clear:
"viewed" is one field with a bunch of dates.
"bought" is another field with a bunch of dates.
"sold" is another field with a bunch of dates.
I want to produce a graph that represents all three different fields according to how many entries (viewed, bought, sold) per month.
I've already tried the graph function, but it produced results that didn't fall into the correct months.
1. Grab dates from a table.
2. Categorize by Month.
3. Count number of entries for that Month.
4. Graph the number of entries for that Month.
Sounds easy, but the trick is that there are three categories that I want to graph. All of them have to be graphed according to the ruleset above on the same graph.
If that's not clear:
"viewed" is one field with a bunch of dates.
"bought" is another field with a bunch of dates.
"sold" is another field with a bunch of dates.
I want to produce a graph that represents all three different fields according to how many entries (viewed, bought, sold) per month.
I've already tried the graph function, but it produced results that didn't fall into the correct months.
