Hi,
for example, I am trying to make a bar chart of all the sales of red trains within each year for the past 4 years, however, the date each of the red trains was sold is in a different field. The reason is because there are 4 colors of trains that can be sold.
so I have one field called {sales.color of train sold} and one called {sales.date of train sold}
that said, I am curious how you can graph this given I need to tell CRXI to pick out only the "red" trains from the {sales.color of train sold} field, and match that up with the date it was sol. I need these two fields to talk to each other. Furthermore, I need a trend line that shows the accumulation of red train sold throughout the past 4 years.
Thanks in advance!
Frank