I’m trying to determine how best to calculate order backlog by using the activity table and event statuses. The calculation would be used to render the data into either a table, histogram or bar chart grouped into week (Round_Week(Event_TimeStamp)). Please share any ideas or code examples.
Question
Calculating Order Backlog
+8Hi Paul,
i would go for a PQL function for the y axis and the round_week on the x-axis. The PQL could be PU_LAST of the status. Then you could combine it with a SUM(CASE WHEN….) where you flag a specific status. It would be nice if you can give a little more information - maybe a screenshot of the table so we can further proceed.
Best,
Flo
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.