Forum Discussion

Thanglm122's avatar
Thanglm122
New Member
1 year ago
Solved

Line Chart Issue

Hi all, 

I am encountering an issue while creating a line chart. Regarding the data, I have daily data consisting of two fields: Date and Value. However, when displaying the data on the line chart, I want the chart to only show the following: the value of the last day of the year preceding the selected report date's year, the value at the end of each quarter of the year for the selected report date's year, and the selected report date (if that date is not the end of a quarter).

Currently, I can only make the chart display the last day of the previous year and the end-of-quarter dates on the line chart, but I am unable to include the selected report date. Please help me implement this.

To make it easier to visualize, the chart I want to create is as follows: