Forum Discussion
Tickets, Open, Closed and backlog
Here's how I would calculate backlog. Feel free to adjust.
Hello lbendlin,
Thanks for your quick reply.
This is exactly what I want, thanks for your help.
May I ask what I did wrong (to learn from my mistakes)
I Will mark this as solved.
Again a great thanks for your help.
Emoes.
Super User- prepare good sample data that fully covers your issue
- try and find a good wording for the expected outcome - I really got confused by the "two month lookback" comment. Ideally show the expected outcome based on the sample data you provided
- note that you can sort one column by another column, and that you can change the sort order of the visual axis after that
- read about active and inactive relationships (needed in your case for the Close numbers)
- when writing measures, test every intermediate step, and test it often, to make sure you're still on the right track. It is easy to get lost in context transitions.