Generating Line Chart With Monthly Data

Hello,    I am currently  working on a line chart and trying to understand the best way to model my data for showing month to month order levels of a product. Currently I have a Entity that holds the year, and month data, and that is connected to a monthly total sales entity.    My question is how should I setup the X and Y attributes in the line chart to show the monthly totals on the Y axis meanwhile aligning to their corresponding Month and year data?    Thank you for any additional guidance. 
1 answers

hii Alexander Eitland,

you can keep months on X axis and total sale of that month on Y axis , and also put a dropdown on the top show all years 

on opening page show to graph of current year if someone want to change year so on change on dropdown of year , filter/change data on graph.



Hope this will help you