Hi, I have a dashboard that shows service tickets count based on different parameters. Now I need to show a trend for current year and previous year for the duration selected by the user in the time picker. For example, if the user selects time from Jan 1, 2023 to Apr 1, 2023 in the time picker , then I need to form a query to select the same duration of previous year( Jan 1, 2022 to Apr 1, 2022) and show the trend . How to create the previous year duration based on the duration selected in the time picker. Please advise.
... View more