Forum Discussion

ea6les82's avatar
ea6les82
New Member
10 years ago

filter empty values in x axis

Hi Guys,

 

I have a report that I use to drill through data. When I drill down into data it looks like the values it populates on the x axis do not get filtered. This causes the graph to expand in size with empty values. For example, I have a graph that shows a count of customers by fiscal month and the first data available begins in July but the graph shows a value of 0 begining in Jan.

 

How can i fix this issue? I also see this when I try to drill through the hierarchy and see employees who do no have any customers because they do not report through whichever manager you decide to drill into. I have a top down drill down for hierarchy.

5 Replies