Aron Glas 2 Posted January 4, 2019 Share Posted January 4, 2019 Happy new year! I've got a question on a complex OVER formula. I would like to display the move count per crane on a specific hour (eg.: hour 1, day 5), as the average moves for that crane on that hour in the last eg. 2 days. How would I do this My result should be a bar-chart with the crane on the X-axis and the move count on the Y axis. Stacked per hour, filter on a specific date. So far I designed a formula that looks like this: (Count([move_id]) OVER (Intersect([hour],[Axis.X],LastPeriods(2,[date]))) / UniqueCount([date]) OVER (Intersect([Axis.X],LastPeriods(2,[date])))) Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted January 8, 2019 Share Posted January 8, 2019 Can you provide the screenshot of the expected output as it is little unclear from description. Link to comment Share on other sites More sharing options...
Aron Glas 2 Posted January 10, 2019 Author Share Posted January 10, 2019 Here you go. Link to comment Share on other sites More sharing options...
Aron Glas 2 Posted January 14, 2019 Author Share Posted January 14, 2019 Done. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now