i need a workaround where the line chart displays a fixed value across the whole chat. The user has the option to specify the start and end date of the project and a goal (number). This goal with the number should be displayed as one straight line starting from the given start and end date.
What I tried was following:
select value, date_dummy from date_dummy
WHERE DATE_DUMMY BETWEEN START_DATE AND END_DATE;
Any idea how to do this.