Exclude values from a dimension in a chart object

[#1]

I have a line chart with a dimension called BookingHour (with values 1 - 23) and an expression called Sum(Tickets). Is there a way to exclude certain values from BookingHour? I would like to only display values 7 - 23 in the chart.

Thank you.

[skaredovs · Accepted solution]

Hi!

sum(if(BookingHour>=7 and BookingHour<=23,Tickets))

Best regards,

Konstantins

[#3]

Just figured it out. In the Axes tab of the Chart Properties box, I changed the Dimension Axis to Continuous. This allowed me to customise the Scale settings. So I entered Static Min = 7, Static Max = 23, Static Step = 1.

[#4]

Hi Konstantins,

I just tried your suggestion and it also works. Actually, I prefer your line of code over changing the Chart Properties as I mentioned earlier. Thanks very much for your quick reply!!!