Graph Help

Discussion created by RishiKhanna on Dec 15, 2015
Latest reply on Dec 16, 2015 by RishiKhanna

I am trying to make a graph based on a specific company's sales,


My table has the CompanyId, CurrentYear, MonthId, CurrentYearSales, PriorYearSales.


I was thinking of searching through the table in order to get the graph to populate


for example:

Searching for months from January- May and for companyId 3 would be searching in my monthId field for 1...5 and my CompanyId would be 3

I tested this and it works,

however i am having trouble making the 1 and 5 into variables and putting data in them


What is a good way to set up a dropdown of months for this to work



Rishi Khanna