1 Reply Latest reply on Nov 8, 2017 1:22 PM by Hari Ankem

    Time between distinct Datetime Timestamps and formating them into buckets

    Sean Macey


      I work for a theme park and am looking to see time between each person riding an attraction. I have a timestamp for when you enter the ride for every person. I am computing the difference between riders which is really simple. Now I want to flag if the time between each rider is between 1 and 2 hours, 2 and 3 hours and so on. This will tell me if the ride has stopped working. Where I run into trouble is each timestamp is a exact datetime and I need to see how this happens at a daily level. I have tried LODs and have not got them to work. {fixed datepart('day', ridetimestamp) , attraction: then the formula for time between rides} but this comes up with an error. Any suggestions?