Forum Discussion
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:
here is a workaround for you. pls see the attachment below
5 Replies
- ryan_mayuSuper User
is 2024/11/20 representing for the data from 10/1 to 11/20? That means a part of Q4
- Thanglm122New Member
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_mayuSuper User