@DylanM @abacon
Hi
I have two years of data. When I try to change the date to year format. I should only get 2022 and 2023 on both ends of the chart. But I am getting a year in the middle of the chart.
Can Anyone give a solution to remove the middle year value 2022?
Attaching image for your reference
Hello @Haripriya, I did some testing and I think I understand the issue now. This seems to be an issue related to the aggregate by year format on a line graph. Since this current year is not completed, when you set it to by year, it is only showing the data for 2022. I tried to force the visual to recognize this year’s data even though it isn’t complete by setting the end date to Start of 2024 but that did not work either. If you notice though, when you switch to Jan 1, 2021 to Jan 1, 2023 it functions as expected.
My recommendation would be altering the Date aggregation to something like Quarters to better handle current year stats or switch to a bar chart where it will show data for 2023 up to the current date.
Thank you for the quick reply @DylanM.
But I wanna use year granularity only. Since it’s showcasing 2022 twice I just want to remove the 2022 which is in the middle. Is there any possible way?
Hello @Haripriya, unfortunately there is not a way to change the formatting for that x-axis field name display unless you removed all x-axis labels. I know you are aggregating by year but you could update the date format to show the month and year option. That way it would show it is displaying the first half and second half of the year since the amount of data is limited to a single year. It displays Jan 2022 and July 2022.
Other than that, there isn’t another workaround at the moment.
Hi @DylanM
Can you please consider this as a feature request.
Hello @Haripriya, yes I can archive this topic and tag it as a feature request!