I have a requirement in which we need to meet the below requirement as explained. Company XYZ is interested in analyzing their data over time. There should be trending capabilities as well as the ability to a time frame compared to the same time frame the previous year(s). The company has ten years of data. They want the ability to load as much of the data as they desire, from two – ten years. The end user should have the ability to decide how much data should be loaded during a data refresh.
so how i need to define a line chart so that above requirement is met.