Basically I've got reports pulling in complaints by month for each of our locations. The graphs are pulling off a query and the query is just filled with the actual complaints and their submission date. Also in the query is a monthnumber function so that the graph organizes the months in chronological order.
My issue now is that some locations didn't have a complaint in April. So the graph jumps from March to May. It's a bit confusing and someone could misconstrue the data if they don't look closely. My question is their a way to populate April, for instance, in the graph but just have the bar be blank.
Thanks!