Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is there a way to suppress (take out) the zero’s in the line graph?

Status
Not open for further replies.

jschill2628

Programmer
Nov 3, 2009
156
US
I have a report, which contains a crosstab report. From the crosstab I created a line chart. In my cross tab I have the following formula {Month2}

{Month2}:
if {@Month} = 1 then "January" else
if {@Month} = 2 then "February" else
if {@Month} = 3 then "March" else
if {@Month} = 4 then "April" else
if {@Month} = 5 then "May" else
if {@Month} = 6 then "June" else
if {@Month} = 7 then "July" else
if {@Month} = 8 then "August" else
if {@Month} = 9 then "September" else
if {@Month} = 10 then "October" else
if {@Month} = 11 then "November" else
if {@Month} = 12 then "December"

{Month}:
Month ({IRSCLAIM.CREATE_DT})

From the cross tab I created a line graph, this line was created to show the difference in incidents from FY to FY, and see the trending. My problem become when the value for a month has been zero, the graph dips down, and is not showing an accurate picture. Is there a way to suppress (take out) the zero’s in the line graph?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top