Static min & max for dimension on chart

[#1]

Hello all,

I have the following dimension in my load script:

TIME(Timestamp, 'hh') & ':00-' & TIME(Timestamp + (1/24), 'hh') & ':00' AS HOUR

which produces 08:00-09:00 (for sales between 08:00 and 08:59), 09:00-10:00 (for sales between 09:00 and 09:59) etc.

I would like to fix the dimension axis on my chart to display 08:00-09:00 to 18:00-19:00 (opening times only) as there are only minor sales outside of this period that I do not want displayed on the chart.

Currently my chart looks like this:

I would like the graph to display just the boxed area.

I've tried adjusting the Static min and Static max boxes on the Axes tab in the chart properties but as of yet can't get it to work.

Any ideas would be greatly appreciated as always.

[#2]

John Witherspoon wrote:
Looks like a combination of the two approaches may be best, and for performance, you might want to load the calculated dimension as a real dimension. See attached. <div></div>

Brilliant, thanks for your help.

APS