RishiKhanna

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

 

Thanks,

Rishi Khanna

Outcomes