Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
HBL
Contributor
Contributor

Year on Year comparison with 2 Date Range Calender for Each year

Hi,

I have a requirement for showing a year on year Line Graph with 2 date filters for each year.

A user should be given 2 Date filters to select their specific date ranges for last year and current year 

Based on the selection of 2 different date ranges, the sum of sales should be displayed in the graph on day wise or month wise 

Example:

Comparison Line graph for last year date range selection(1st Oct 2018 to 10th Oct 2018) and current year date range selection(1st Oct 2019 to 10th Oct 2019)

I need help in developing this functionality with "Date Range Picker Extension" as I am using the same for all the other apps 

Or you can suggest me any other Extension which would support this functionality

Labels (3)
2 Replies
sugathirajkumar
Creator
Creator

Can you please provide the sample file?

HBL
Contributor
Contributor
Author

I have attached the Excel Data and the .qvf file. 

Years:16-17 and 17-18 "Date Range Picker Extensions" have been placed with the line graph in the .qvf

Let me know if you need anything