In stacked bar combo chart, we are projecting contact created date(x-axis), number of users(bar), and new users(line). However, some months are missing from the chart because no new users were created during those months. We want to display these missing months on the chart with a value of “0”. Is there a way to achieve this and display all months with either their actual value or a value of “0”?
In the below image, we can see only March month with number of users, but we want to show all the months with value of “0”.
We have enabled the “Show date gaps” feature. When I select “all” in the year filter, it fills the gaps between months. However, when I choose the year 2024, only the month of March is displayed on the x-axis since we don’t have data for the other months. We need all the months from January to December to be displayed with a value of 0, except for March. Is there any way to achieve this?
