5 day only on graph

[djeddie]

Hi All,

I'm using CR9.5

In my report i want to create a graph that only displays the last 5 days on the 'x' axis. The group that the graph is located in is a datetime group that contains data recorded at 15min intervals.

What can i do to have this graph only display the last 5 days worth of info??

 

[IanWaterman]

Add a date range parameter and use that in your select statement to restrict dates to the range you want.

Ian

 

[lbass]

What is the interval that you are grouping on? Day? If so, the chart will need to be in the report footer, not in a group section. If you need the report to contain more than five days worth of data, but want the chart limited to five days, then you could create a formula like:

if {table.date} in currentdate-4 to currentdate then {table.date}

Then use this formula as your "on change of" field. You would have to select it in the chart expert->order and choose specified order so you could choose the 'others' tab and check "discard all others".

-LB