Slide with Last Hours?

[#1]

Hi guys, ive got a tricky one that has made me scratch my head for a while now.

I need to sum certain dimension, so lets call it Sales for demonstration reasons, but the user needs to have a slide, the slide consists of numbers from 1 to 24, which represent hours.

So if the user moves the slide to 10 it will show me sum(Sales) for the last 10 hours.

This will ideailly need to work when its 2AM and I need the last 10 hours, it would show me the sum(sales) since 4PM the previous day.

And so on as the user moves the slide around

Many Thanks

[MK_QSL]

Nice one.... Could you please provide some sample/dummy data to work... Would like to work on this...

[#3]

There you have a CSV file, theres 4 colums, TimeTaken, ChangeDat, Ticket and Operator,

I would like to show the TimeTaken and the number of distinct tickets for each operator, within the SLider TimeFrame.

Thanks

[#4]

This is the formula without slider

=sum({<ChangeDat = {'>=$(=timestamp(time(now()-'12:00')))'} >} TimeTaken)

So for the Slider, just create a Inline Table, and call the Inline Table by replacing it with the 12 and leaving the ':00'

Thanks