Line Chart Issue

[Thanglm122]

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:

[ryan_mayu]

is 2024/11/20 representing for the data from 10/1 to 11/20? That means a part of Q4

[Thanglm122]

@ryan_mayu no, it's the data at 2024/11/20. Data at Q3/24 is data at 2024/09/30, Q2/24 is 2024/06/30 and so on

[ryan_mayu · Accepted solution]

@Thanglm122 

here is a workaround for you. pls see the attachment below

[Thanglm122]

Wonderful. Many thanks @ryan_mayu 

[ryan_mayu]

you are welcome